Apple Newton Connection Utilities (for Macintosh) User Manual

Page 48

Advertising
background image

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.

Advertising