String length -1 ?

[Hamder83]

Hi 

I have a series of strings including a control digit - i wanna compare to a 2. data source were the string comes without the control digit.

So basicly i wanna do string length -1 .. since the string comes in various lengths, i cant just do a left ..

So?

[WilliamR]

Hello @Hamder83 ,

can you give us some data as an example?

[RolandSchubert · Accepted solution]

Hi @Hamder83 ,

you could use the formula

LEFT([Field], LENGTH([Field]) - 1)

with LENGTH finding the number of characters in string. If there are strings with length 1 within the column, you should add a condition to check:

IF(LENGTH([Field]) > 1 THEN

LEFT([Field], LENGTH([Field]) - 1)

ELSE

[Field]

ENDIF

Hope this is helpful

Best

Roland