Thanks, Mike - I'll look at the text file a little closer. Sami
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Monday, September 20, 2010 3:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Loading in VARCHAR data 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
