timport recdelim

Post Reply
gazim
Posts: 66
Joined: Sun Feb 18, 2001 1:01 pm

timport recdelim

Post 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"ýþ
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

timport recdelim

Post 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
Post Reply