When you import a delimited text file, you can specify what characters
separate information in the file. For example, fields of information might be
separated by commas (,) and entries (records) might be separated by return
characters.
You can also specify whether the text file includes column headings (field
names) at the top of the file.
By default, the Newton Connection Utilities import delimited text files with
the following format. You can change these settings. See “Setting
Miscellaneous Options” in Chapter 10, “Setting Advanced Options,” for
more information.
The following is an example of a delimited text file that uses tabs to
separate fields:
"First"
"Last" "Street"
"City"
"State" "Zip"
"Phone"
"Michael"
"Jen"
"333 West Point"
"San Juan"
"CA" "94000"
"(415)555-1234"
"Sheila"
"Black"
"222 West Mark"
"New York"
"NY"
"10000"
"(212)555-4321"
"Sanjay"
"Manni"
""
"Dallas"
"TX"
"75111"
"(214)555-4444"
"Ian"
"Smit" "555 Minny Dr" "Atlanta"
"GA"
"50000"
""
"First","Last","Street","City","State","Zip","Phone"
"Michael","Jen","333 West Point","San Juan","CA","94000","(415)555-1234"
"Sheila","Black","222 West Market","New York","NY","10000","(212)555-4321"
"Sanjay","Manni","","Dallas","TX","75111",("214)555-4444"
"Ian","Smit","555 Minny Dr","Atlanta","GA","50000",""
48
Chapter 5
Column headings
show the
field names.
Column headings
Fields of information
are separated by tab
characters.
Blank fields are marked
by quotation marks ("").
Blank fields are marked
by quotation marks ("").
Fields of information are
separated by commas.
