Splitting Fields

  • Thread starter Thread starter HankW
  • Start date Start date
H

HankW

I have a field that currently contains "Last Name, First Name". How can
I split apart the "Last Name" and the "First Name" based on the comma?
In excel I can use the find function, what can I do to replicate that
in Access?
 
Hi,


InStr(string, substring) could be use to find the first position of the
substring in the string.


Left( string, InStr( FullName & "," , ",") -1)


and


Mid( string, InStr( FullName & "," , ",") -1)


could split the field accordingly to the presence of the first coma.


Hoping it may help,
Vanderghast, Access MVP
 

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

Multiple Commas 3
Splitting a Field Question 2
Split data in field on character return 0
Access to split First and Last name 0
Splitting a Field 1
Splitting a field 1
reformatting a name 2
Split the contents of a field ie - full name into first and last n 3

Back
Top