trim to first "-" character

K

Keith

Sorry if this is posted again, but I couldn't find my post.

How do I trim off everything to the left of the first "-"? The number of
spaces are different (to the left of the first "-") so I'm hoping there's a
way. There's always a way!


(abc) -PLhagdr-hdk
(ded ) -GHld-usj
(ab) -hgrh-isjb

Results would be:
PLhagdr-hdk
GHld-usj
hgrh-isjb
 
X

xps35

Sorry if this is posted again, but I couldn't find my post.

How do I trim off everything to the left of the first "-"? The number of
spaces are different (to the left of the first "-") so I'm hoping there'sa
way. There's always a way!

(abc)   -PLhagdr-hdk
(ded ) -GHld-usj
(ab)  -hgrh-isjb

Results would be:
PLhagdr-hdk
GHld-usj
hgrh-isjb
Click to expand...

Mid([YourField],InStr([YourField],"-")+1)

Groeten,

Peter
http://access.xps350.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim 1
How do you trim characters? 6
Writing SQL code to delete duplicate records 0
First Character to Lowercase 2
How to trim a character from a cell ? 8
Error in Microsoft Encryption Sample? 2
Function to look for alpha character 2
Change "-" from right first character to left first character to make a negative amount 2

Top