|
| 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
December 13th, 2009, 07:58 PM
posted to microsoft.public.access
|
|||
|
|||
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
December 13th, 2009, 08:11 PM
posted to microsoft.public.access
|
|||
|
|||
|
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
December 13th, 2009, 08:26 PM
posted to microsoft.public.access
|
|||
|
|||
|
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 | |
|
|
Linear Mode
