>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.
Venelina Jordanova
Outsourcing IT Services Ltd.