RTrim to first blank space 1

[WestView]

Hello all,

I have a field that generally holds to this format: FirstName <space> LastName <space> E-Mail Address. I need to remove everything but the e-mail address.

I thought the best way to accomplish this was to use something like the RTrim() function to the first blank space (end of last name). Can't get the syntax right.

Please HELP!!!

Thanks,

- Tom

 

[PHV]

You may try something like this in the query grid:
EMail: Mid([your field],1+InStrRev([your field],' '))

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

 

[WestView]

PHV,

Excellent! Worked like a charm!!!

Many Thanks,

- Tom