Bill,
I would suggest to add a second name column (ALTER TABLE) to the table after the import. Then you can convert your data as follows:
REPLACE new_column WITH ALLTRIM ( GETWORDNUM(original_col, 2, ",") ) ALL
REPLACE original_col WITH ALLTRIM ( GETWORDNUM(original_col, 1, ",") ) ALL
This way, you'll have the firstname in the added column and the lastname in the original column.
HTH,
Armin
>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,