GETWORDNUM doesn't seem to be a function available with VFP 6. Do you know where I can get it?
Thanks
>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,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!