AnsweredAssumed Answered

Importing Tab Separated Text Files

Question asked by BMarot on Sep 30, 2009
Latest reply on Jun 28, 2010 by FentonJones


Importing Tab Separated Text Files


I am attempting to populate my solution using a number of tab separated text files.


As an example, let's say I have 4 fields (Last Name, First Name, City, Notes).  My tab separated text file will contain information like:


Last Name      First Name      City      Notes Jones          Henry           Vancouver This is an example of a note Smith          John            Montreal  Another example of what a note may look like.

The part that is giving me troubles is the notes field.  Some of the notes may be several lines long and may contain a number of line/paragraph breaks or other formatting.  Is there any way that I can retain line/paragraph break structure so that the information doesn't look like a jumbled mess when it's imported into the notes field? 


I'm on a Mac running OSX 10.5.8 and I am using FileMaker Pro 10.