LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: JohnPD

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.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ThomasT

Hi John.

Could you submit an example?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: JohnPD

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

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ThomasT

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

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

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.