Split Excel Column into two FMP fields

[rsgfmp]

I tried to search for this prior to the post, but I was unsuccessful, so a quick question:

I have an Excel table with a column labeled name. Unfortunately, the format of this column is "Last, First". Is there a way I can import this column into two fields, "Last Name" and "First Name". Basically, I need a way to split a column with a comma into two columns to import. Any thoughts?

Shane

[Lee Smith]

There are two simple approaches (v6 and before). One is to create a field for LastName and FirstName, with these calculations, and text results:

LastName =

LeftWord(YourField, 1)

FirstName =

RightWord(YourField, 1)

The another way would be to run the file through a Text editor, such as BBEdit, and do a find and replace using Grep patterns.

Speaking of Grep, they are now available in version 7, so you might find it easier to use them instead of the calculations I gave.

HTH

Lee

[rsgfmp]

Thanks Lee!