Text files

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I want to find a way to put a delimiter in place of the first space in a
line of text which i can use to separate email address from a name

I get a list of names like the following

(e-mail address removed) John M. Citzen Jr.

and so i want to put a comma in place of the first space.

Is this possible

Craig
 
Hi Craig,

It's possible.

If this list is in a text file, the simplest approach if you're not used
to writing code is

1) import the text file in the usual way so the email address and name
come into a single text field. Let's call this "F1"

2) add two text fields to the table, one for name and the other for
email. Let's call them "Person" and "Email".

3) create an update query that uses expressions to extract the pieces
from Person and put them into the two new fields. You'd update Person to
something like
Mid([F1], InStr([F1], " ") + 1)
and Email to
Left([F1], InStr([F1], " ") - 1)
 
Back
Top