Importing lengthy field contents with multiple lines
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.