If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
trim to first "-" character
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 |
#2
|
|||
|
|||
trim to first "-" character
On 13 dec, 20:58, Keith wrote:
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 Mid([YourField],InStr([YourField],"-")+1) Groeten, Peter http://access.xps350.com |
#3
|
|||
|
|||
trim to first "-" character
The general expression would be
Mid(FieldName, Instr(FieldName,"-")+1) -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|