Steve,
You have to have QUOTEs to differentiate the TEXT values vs. NUMERIC.
If you are using R:BASE 6.5++ (Build:1.866xRT03) or higher, take a look at the sample SpreadST.RMD file to automate entire routine.
If you can't find SpeadST.RMD, let me know and I'll send it you.
Very Best R:egards,
Razzak.
At 10:52 AM 9/25/2003 -0500, J. Stephen Wills wrote:
Thanks, Razzak, but all those are a-okay. That is, there are no QUOTES in the ASCII-CSV file ... umm, if this is so, then should I have set the QUOTES CHAR to a NULL before the LOAD? I'd love to know.
However, when I executed this using GATEWAY, as I recalled you, Et Al., having advised once in the distant past, everything worked fine.
Thanks, Steve in Memphis
----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 10:39 AM Subject: [RBASE-L] - Re: Problems with LOAD ... AS CSV? - Razzak's Reply
> > Steve, > > A few things to consider when IMPORTing/EXPORTing data as CSV. > > 01. Database CHARacter SETting for QUOTES > > 02. CSV file settings for QUOTES > > Check to make sure that QUOTE SETings are correct. > > Hope that Helps! > > Of course the Next Generation R:BASE 7.0 for Windows includes > the OPTION to SET your own QUOTE SETtings for GATEWAY EXPORT > and GATEWAY IMPORT commands. > > Very Best R:egards, > > Razzak. > > Unbounded Possibilities with Industrial-Strength, True-Relational > and Multi-User Database Management System. > > > At 10:25 AM 9/25/2003 -0500, J. Stephen Wills wrote: > > >I'm trying to execute the following statement > > > >LOAD HOLD_CLIENT FROM > >D:\BBER\PROJ_WIA\CLIENT\DATA_EXTRACTS\CLIENT_2003_APR_B.csv AS CSV > > > > > >W/this particular file, there are 288 records. The target TABLE f/the > >LOAD is structured exactly as is the data, w/19 Fields (this is just > >f/info) of NOTE Data-Type - this table was copied fm the one originally > >created via UTILITIES|IMPORT/EXPORT|... New Table=Checked|TRUE, so that's > >why the NOTE fields. Again, this is f/info, although I wonder if this has > >anything to do w/executing this fm the command line. > > > >Anyway, the command runs fine, LOADing the 98 records, but it doesn't STOP > >execution, continuing to LOAD data, but fm where/what I cannot say, until
> >I press [ESC]. Then, it has literally K's of "garbage" records, mostly > >w/NULL values, although it seems to keep populating at least one field > >w/"8" the last character of the ID value of the last record in the CSV, > >which is the last field in the record, so it seems to be re-loading the > >very last byte of the CSV file w/o halting. > > > >So, any thoughts? I'd really like to proceduralize this task, but I'm not > >sure what to do now. >
