Extracting data from field on import

[kiwiora]

Some nimwit user has created an excel spreadsheet that i am now trying to import into filemaker.

My problem is this... they have a cell for the name of client i.e Joe Bloggs, but for data manipulation, when i import, i want to separate this into two fields i.e. first name Joe and surname Bloggs.

even if i could bring it into one field, and then from that field perhaps extract the first name / surname using the "-1" type function???

otherwise I am sending the user back to their excel spreadsheet to manually fix.. hehehe

[RussBaker]

In my sample file "RussCalcs From Oz" under the thread title of "Handy Bits" in the samples Section of this forum there is an example of how to do this. If you click on the view column header in the forum, Handy Bits will be near the top.

Scroll down towards the end of the post to get the latest version (v4).

Have also emailed you the draft v5 of RussCalcs From Oz (which includes a better parsing calc).