Jim: That is so old-school elegant.
bruce/safesectors > -------- Original Message -------- > Subject: [RBASE-L] - RE: Gateway / Append command > From: James Bentley <[email protected]> > Date: Fri, January 08, 2010 11:58 am > To: [email protected] (RBASE-L Mailing List) > > > If you can't find a complete solution in RBase consider doing the following: > Output the .csv's to two separate file and keep track of the file nanes > > Write out a .BAT file > COPY /A filename1.csv + /A filename2.csv newfile.csv /A > > Then LAUNCH the .BAT file > > If you have problems with content of file try replacing '/A' with '/B' > > > Jim Bentley > American Celiac Society > [email protected] > tel: 1-504-737-3293 > > > > > ________________________________ > From: "[email protected]" <[email protected]> > To: RBASE-L Mailing List <[email protected]> > Sent: Wed, January 6, 2010 10:08:49 AM > Subject: [RBASE-L] - RE: Gateway / Append command > > > I am not using Excel at all. > > In Rbase I am creating a CSV text file with very strict formatting > parameters. > It is not used by Excel nor is Excel involved in creating it. I state that it > is a CSV file where in reality it is simply a TEXT file. However GateWay > Export does not list .TXT but only a .CSV, which is fine. > > I can create this CSV text file with a Gateway Export command line. > So far no problem. > > I then need to add to this same file, at a later point in processing. So I > need > the Gateway Export command to do an APPEND to the end of the > previously created file. This is where the problem is, in that while the > DB Explorer version of Gateway Export has an APPEND option, I have > been unable to find a command line syntax for it. Evidently it does not > exist. > > I will have to find another method of creating this text file other than using > the Gateway command. This program will run 24/7 and must run without > user intervention or other outside influence. > > There is always more than one way to accomplish a given result, I will just > need to move on in a different direction. > > Thanks, > -Bob > > > > > ----- Original Message ----- > From: "Paul InterlockInfo" <[email protected]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Wednesday, January 6, 2010 9:21:29 AM GMT -06:00 US/Canada Central > Subject: [RBASE-L] - RE: Gateway / Append command > > > Is it Excel 2000 or 2007? What flavor is it? > > Can you run any macros from Excel? On/at the workstation that does this > process. > > Sincerely, > Paul D. > > > > > > > From:[email protected] [mailto:[email protected]] On Behalf Of > [email protected] > Sent: Wednesday, January 06, 2010 8:21 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Gateway / Append command > > Thanks for the suggestions, but in this case, I need to be able to > simply add data to the end of a CSV file. This is being used in > conjunction with EDI and has strict parameters such as end of line > characters, character spacing, etc. etc. The Gateway Export command > allows for some formatting options via an RGW file that are desired/needed. > > I tried using the OUTPUT ... AAPPEND and then UNLOAD Data. > While that does append to the end of the file, I do not have the formatting > options that are available in Gateway. > > I am able to produce the exact output needed via Gateway Export, but I > cannot find the option to append an existing file. It is possible as there > is an APPEND option when using the DB Explorer bar, but I need to > use the command line. > > An interesting note... when using the Gateway Explorer bar, and you > select CSV file type, check the APPEND option and then export, the > file is indeed appended. However if you select the USE EXPORT > WIZARD, check the APPEND option and then proceed using the > wizard and export the file, it does not append. > > Any input on the GateWay Export line command and how to get it > to APPEND to an existing column would be greatly appreciated. > > Thanks, > -Bob
