Thanks much for the reply. How do I get the separated first and last name to populate new columns. The following is not working? as I get the same first name and last name in all records?
USE C:\MAILFILE.DBF IN 0 EXCLUSIVE
X = FLNAME
SURNAME = GETWORDNUM (X, 1, ",")
FIRSTNAME = GETWORDNUM...
I'm using foxpro/sql
I have a name field but unfortunatley is has both the first and last name within the same field. As noted above 'Johnson,Emily'
How do I parse out the name into different fields?
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.