FIELD function
Posted: Fri Sep 25, 2015 8:18 am
All, need a quick help on field function.
I have a name- ASHLEY, MARTHA ANNIE
This is char(30) column and need to separate it to first name,last name and middle name, three separate column. Used FIELD function below.
LAST NAME- FIELD(name,',','1')
Last name worked. But got stuck in first and middle name.
It should be,
Last name- ASHLEY
First Name-MARTHA
Middle name-ANNIE
Appreciate your help.
I have a name- ASHLEY, MARTHA ANNIE
This is char(30) column and need to separate it to first name,last name and middle name, three separate column. Used FIELD function below.
LAST NAME- FIELD(name,',','1')
Last name worked. But got stuck in first and middle name.
It should be,
Last name- ASHLEY
First Name-MARTHA
Middle name-ANNIE
Appreciate your help.