right trim

[tomk01]

I cant seem to get this right. I'm trying to take a filed that looks like this :

Field
1)
12)
12345)

and chang it to look like this

field
1
12
12345

ir trim or rtrim the right command? how do I use them?

 

[PHV]

You may try this:
Left(myField, Len(myField)-1)
Or this:
Left(myField, InStr(myField,")")-1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JonFer]

Trim, RTrim, and LTrim just remove leading/trailing spaces. It would be nice if they accepted a parameter for other characters but they don't.

John

http://www.interautomateconsulting.com

 

[Golom]

Or This

Replace(myField, ")", "")