Trim last two characters

[Anonymous]

Trying to trim the last 2 characters (could be text or number) from a field with a variable number of total characters.  Could be staring with 200000WS and want 200000 as the result, or 789ABC123456YT4X and want 789ABC12345YT as the result.  Will index work for this?  I thought Left ([Item_number], index([Item-number],'')-2) might do it by jumping back 2 spaces from the the first balnk (the end of the string) but it returns the whole string.

[Alexander_Thor]

Try left(YourField, len(YourField)-2)

[Anonymous]

No, it doesn't seem to work either.  I still get the entire field.

[Alexander_Thor · Accepted solution]

That is strange. Attached is a sample application that does what you want, trims 2 characters from the right.

Press Ctrl + E inside the app to see the script.

[Anonymous]

Thanks a bunch Alexander, I got it.