I am trying to separate a varchar (40) name field into 3 fields.
Last Name
First name
Middle name
The only thing that separates the name on the input file is spaces, none of the fields are in a fixed position.
Example of Input:
Mary Ann Jones
Joseph D Anderson
Lawrence Ambrose Olson
This...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.