1 Reply Latest reply on Jul 6, 2009 4:47 PM by comment_1

    import excel with /// in the fields

    engrav

      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