Splitting data from one filed into 2 fields.

[Guest]

I know how to concatinate from 2 fields into 1, but is there a way to
reverse this? For expample I would like to spit my names field into a First
Name filed and a last name field. Is there a way to do this?

Example
Field is
Customer Name
John Smith (would like to see if it can be change into)
Fname John; Lname Smith
Thanks,
Tara

 

[Guest]

There is a way, but it is not clean unless you have a unique delimiter
between the first and last name. I.E. the scenerio where the last name it
two words such as Van Buren or a first name that is really two names such as
Billy Joe.

This is a quick way to do it but does not take into account the scenerios
above.

x = "John Smith"
y = left(x,instr(x," "))
?y
John
z = right(x,len(x)-instr(x," "))
?z
Smith