AnsweredAssumed Answered

Importing lengthy field contents with multiple lines

Question asked by MattSchuurman on Jan 21, 2013
Latest reply on Jan 22, 2013 by 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

Outcomes