I have had the same problem. open up your input file with notepad, go to the end of the file, I bet there is a garbage line right at the end. Positiion your cursor at the end of the last line of good info and hi the delete key, that should remove the last line.
rich ----- Original Message ----- From: "J. Stephen Wills" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 11:58 AM Subject: [RBASE-L] - Re: Problems with LOAD ... AS CSV? - Razzak's Reply > Also, while I have seen an announcement about v7, I haven't rec'd an e-mail > fm sales about upgrade procedures, pricing, etc. > > What's the buzz? > > TIA, > 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. > >
