11 Replies Latest reply on Jan 22, 2013 3:46 PM by MattSchuurman

    Importing lengthy field contents with multiple lines

    MattSchuurman

      Title

      Importing lengthy field contents with multiple lines

      Post

           I'm importing records into a database from an xls file. The xls was generated by a web-based database. One of the fields in the web-based database is a text box (Biography) that can contain lengthy pieces of text, including carriage returns.

           When the website generates the xls file, each carriage return creates a new row. When I import the xls into Filemaker Pro, each row creates a new record. As a result, I get over 1000 records instead of the actual 100 there should be.

           Is there a way to fix this in Filemaker so that my text box content doesn't get broken up and distributed over several records?

           Using Filemaker Pro 9.

      Picture_1.jpg