ASPDEV
asked on
Parse string in Visual Fox Pro 6.0
Hello Experts,
I need to parse the LEFT & RIGHT string , which is being separated by comma.
Name
-------------
JOHN,SMITH
When I tried LEFT(Last_Name , AT(",", Name)-1) I get JOHN. How can split other half i.e right of the string????
I need to parse the LEFT & RIGHT string , which is being separated by comma.
Name
-------------
JOHN,SMITH
When I tried LEFT(Last_Name , AT(",", Name)-1) I get JOHN. How can split other half i.e right of the string????
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.