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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Extract Text from decimal separated string 6
Access to split First and Last name 0
Extract a text between two last parentheses 3
Extracting data from string 5
extract 3 numbers from a string 0
Extract first part of text string 1
Find character in a string 2
Return string using RIGHT function 4

Back
Top