AnsweredAssumed Answered

import excel with /// in the fields

Question asked by engrav on Jul 6, 2009
Latest reply on Jul 6, 2009 by comment_1

Title

import excel with /// in the fields

Post

FM Pro Advanced 10.0v1

MacOS X 10.5.7

I have excel files with fields containing multiple entries separated with ///.

Can I somehow import these into FM and get a separate record for every item.

For example, excel has

cell a1 aaa cell b1 bbb

cell a2 ccc cell b2 ddd /// eee

can I import and get 3 records

aaa bbb

ccc  ddd

ccc eee

thank you 

Outcomes