Access search text string for char, then extract all to right?

  • Thread starter Thread starter CVBetty
  • Start date Start date
C

CVBetty

My imported string looks like this

ACH SOC SEC 310*First Last
I want to access to find the * in the string then extract First Last
 
In a query:

FirstLast: Mid([FieldName],Instr([FieldName],"*")+1)

I'd recommend this as the first step. If you want to further split first and
last, there could be problems such as names like Greg von Leghman or Mary Ann
Day.
 
Back
Top