09-09-2015 09:37 AM
Hi I have a city,state field - variable length. I need to output the city and in another field output the state field. Basically have one field but need to output two fields but it is variable: For example: New York, NY
White Plains, NY
09-09-2015 09:42 AM
Use the scan() function. Like
city = scan(city_state,1,','); state = scan(city_state,2,',');
Take care of defining the target fields with appropriate lengths.