Extracting Part of Field

[Ron]

I have a colum with the customers first name and last name
in the field. But i need to seperate them and place them
in two different colums names "First Name" and "Last
Name". There is always a space between the first name and
last name, and of cource the first name and last name vary
in length.

I can't do it with "left([FieldName],3)"

How do i write the expression to seperate them?

 

[R]

To get first name:

left([name],InStr([name]," ")-1)

To get last name:

Right([name],InStr([name]," "))

I have ways to pull the middle name/initial also, if you need them. Let me
know.

-Renee

 

[Maggic]

I didn't ask this question but it is something I need to do with data I
imported ... thanks for the solution!

Maggic

To get first name:

left([name],InStr([name]," ")-1)

To get last name:

Right([name],InStr([name]," "))

I have ways to pull the middle name/initial also, if you need them. Let me
know.

-Renee

I have a colum with the customers first name and last name
in the field. But i need to seperate them and place them
in two different colums names "First Name" and "Last
Name". There is always a space between the first name and
last name, and of cource the first name and last name vary
in length.

I can't do it with "left([FieldName],3)"

How do i write the expression to seperate them?