trim to first "-" character

  • Thread starter Thread starter Keith
  • Start date Start date
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
 
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
 
Back
Top