Page 1 of 1

timport recdelim

Posted: Thu Feb 10, 2005 2:05 pm
by gazim
I am experiencing some problems with the schema file's recdelim and csv parameters. I would like to use chr(251)+chr(252) for csv and chr(253)+chr(254) for recdelim. It appears that no matter what I use for recdelim, it always looks for CR\LF in the delimited text file.
TIA.

excerpts from my schema and delimited text files.
schema:
database /database/test1
table tbltoshio
csv \FB\FC
keepfirst
#keeps the formatting for OCR text
recdelim \FD\FE
noid tbltoshio

#Name Type Tag
field ID varchar(100) 1
field OCR blob 2

textfile:
"ED0708199"ûü"POLICIES AND ENDORSEMENTS"ýþ
"ED0708224"ûü"POLICIES AND EMPLOYMENT"ýþ
"ED0708229"ûü"ORIGINAL MEMO"ýþ

timport recdelim

Posted: Thu Feb 10, 2005 2:52 pm
by mark
"csv" is a specific format. A rec delim other than newline isn't csv. You'll need to write a recexpr to match your records or make them conform to csv. If you data has newlines in them use double quotes (") around the field. See http://thunderstone.master.com/texis/ma ... 3bc212d810