Extracting portion of varying lenth field - everything except last character

[smmedeiros]

Can anyone share a method to extact all characters of a varying length field.. ALL but the very last character - mixed character type alpha & numeric

For example
abcd1234
results desired -> abcd123
abcde
results desired --> abcd
123ab45
results desired --> 123ab4


Thanks

 

[AndyMc]

left({YourField},len({YourField})-1)

 

[AndyMc]

The above formula assumes that the field has something to drop at the end. If it has a length less than 2, then it will error. If so, try:

stringvar strng := {Yourfield};
numbervar lngth := len(strng)-1;
if lngth > 0 then left(strng,lngth) else strng

 

[smmedeiros]

AndyMC
Thank you for the help and quick reply!