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

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
 
J

Jerry Whittle

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.
 
Top