LTrim Help Needed.

Topic

New Reply

Hi All,

I want to trim all in a text field except the last letter / value. So if I trimmed ‘DaveShmaveX’ (without the quotes), I’d only be left with X. I’ve looked at the online help and have messed around with this for a while with no success.

Can someone clue me into how you’d trim all but the last letter / value?

TIA

Dave

Reply | Quote

Replies

You can get the result you need with Right(FieldName,1)

Reply | Quote

A quick caveat here: if you have any trailing spaces in your names, a la

"DaveSchmaveX  "

, taking the right-most 1 characters will get you the space. You may want to use the Right() function in conjunction with the Trim() function which will trim off all preceding and trailing spaces:

Right(Trim([FieldName]),1)

Reply | Quote

Thank you both, Shane and Judy! It’s much appreciated.

Dave

Reply | Quote