Results 1 to 5 of 5

Thread: Need help: Length field says 8 but is 7

  1. #1

    Default Need help: Length field says 8 but is 7

    Dear all,

    I have a problem with one cell in my column, where Lavastorm says the length (len) is 8 , but it's actually 7.
    I've tried to remove it with the trim() formula but this does not work.

    Additional information:
    I work in the Netherlands, perhaps that's relevant since Lavastorm is from the US.

    Can anyone please help me to solve this matter?

    Thanks in advance.

    Kind regards,

    JohnPD.

  2. #2
    Contributor
    Join Date
    Apr 2011
    Location
    Copenhagen
    Posts
    144

    Default

    Hi John.

    Could you submit an example?

  3. #3

    Default

    Hello ThomasT.

    Hereby an example:
    Number1 Number2
    4598085 4598085

    From both columns, the length of the data is 7, but the first one is 8 according to the len() formula

    For this reason, the formula where Number 1 <> Number 2 shows 1 record, but it's actually the same so it should show 0.

    I hope this is a workable example ThomasT.

    Cheers

  4. #4
    Contributor
    Join Date
    Apr 2011
    Location
    Copenhagen
    Posts
    144

    Default

    I only get 7 on both occasions.
    Have you tried strLen() function?

  5. #5
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    799

    Default

    While displaying that data in the BRDviewer, select the two cells, and press CTRL-X
    Then paste that result here.

    It will help us see more about the data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •