My SplashID example: 320 records, 16 different templates.
So far I have:
Exported from SplashID:
selected all the records that share a template.
export these as a CSV file.
each record has 12 fields,
each record is terminated with CRLF (0x0D, 0x0A).
file looks good with 2 exceptions:
(a) notes field can contain New Line characters (0x0B)
fields can contain commas (but are enclosed in quotes when they do, and only when they do)
Import as CSV format.
How can I get 1Passport to recognize the quotes and ignore the encapsulated commas (i.e., not terminate the field)?
Will Passport1 handle the New Line character OK?
(I haven't got that far yet, but just thought I'd ask in case anyone knows.)