>>Hi, all
>>
>> I imported an excel spreadsheet into VFP. I need to split a column that contains names into two separate columns. For example:
>>
>>Name Smith, John
>>
>>Into
>>
>>Last_name Smith
>>First_name John
>>
>>Is there a function to do this?
>>
>>TIA,
>
>You can not split columns on the import time. Instead you can add new columns to the resultant table and to fill them with split text. You can use AT(), LEFT(), SUBSTR() command to split the text.
Do you know what the exact syntax is?
Thanks,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!