Sami,
It wouldn't be the hard returns.
CR/LF is permitted in varchar, however if there are embedded nulls Char(0)
that is a deal breaker in any RBase text or note or varchar field, however
if the new BSTR datatype on the horizon (details to be revealed at the
conference IIRC) would accomodate embedded nulls.
Mike
----- Original Message -----
From: "Sami Aaron" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, September 20, 2010 4:26 PM
Subject: [RBASE-L] - Loading in VARCHAR data
Is there a way to load a text file into a VARCHAR field if there are
embedded hard-returns within the field in the text file? Is there a setting
to NOT assume the CRLF is the end of record mark?
What happens is that the end of file mark is never reached and the database
just gets bigger & bigger until I kill it.
Here's what my import file looks like:
~39310~|~102991~|~102991~|~AD02956~|~Valuation for Claim No:
AD02956~|~Delivery Date: 09/20/2010 2:12:33 PM
Company: WEST BEND MUTUAL
Claim Number: AD02956
Year: 1994
Make: KOBELCO
Model: SK400 LC III
VIN: 00570
ID: 102991
ACV: $46,793.00~|~09/20/2010 02:12PM~|~4~|~~|~X~|
Everything from "Delivery Date" to the next "~" is data for one VARCHAR
field.
Here's my code to import the file:
SET DELIMIT=NULL
SET DELIMIT='|'
SET QUOTES=NULL
SET QUOTES=~~~~
LOAD ImportEmail FROM .xFilename_Email AS ASCII
SET QUOTES=NULL
SET QUOTES=''''
SET DELIMIT=NULL
SET DELIMIT=','
Thanks for any ideas!
Sami
____________________________
Sami Aaron
Software Management Specialists
913-915-1971
[email protected]
Please consider the environment before printing this e-mail
