Bob, > I have at this time met my requirements by doing your second > recommendation of creating a variable with all the columns and > adding a comma between each.
Just a word of caution. You should either enclose any text columns with quotes, or test the value of each text column for commas and enclose those column values with quotes if comma(s) exist. Ben Petersen On 16 Dec 2003 at 11:32, Thompson Technology Consultants wrote: > Emmitt, > I am using V7 (updated this morning). This would be > a resolution to my situation, except that for some reason, I cannot > get a TEXT file to "work". When I output to a text file, it creates > the file, but there are no contents. Size is 0. I have selected > the controls under the Text File setup and they show as selected. > (High lighted them under Available Controls and moved them under > Selected Controls) > > If I print to a RTF format, it works fine, but not to a TXT format. > > I have at this time met my requirements by doing your second > recommendation of creating a variable with all the columns and > adding a comma between each. I then output to RTF and simply > rename the file to a CSV extension. It seems to work OK! > > However, I would like to determine what I am doing wrong on the > TXT format file or if it is something I need to submit to RBTI. > > Thanks for your input! > -Bob > > Thompson Technology Consultants > 276 Chippewa > LaPorte, IN 46350 > 219-324-2605 (Phone & Fax) > 219-363-7441 (Cell) > http://ttc.inc.home.comcast.net > > > > -----Original Message----- > From: Emmitt Dove [SMTP:[EMAIL PROTECTED] > Sent: Tuesday, December 16, 2003 11:10 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: CSV report output > > Bob, > > You don't mention which version of R:Base. If you're using 7, check out > the Print to Text File Setup Options (on the File menu in Reports > Designer). You can now use a v7 report to print a detail-only, fixed > format text file or comma-delimited text file. Or, you can do what we do > and build up a variable in code and then write the variable to a text file > line-by-line. We use this for EDI exchanges with a logistics provider. > > >I seem to remember a thread about outputting a report to CSV format, > >but I could not find it. > > > >I am writing an EDI application and need to create a CSV file. I know > >I can EXPORT through Gateway, but it poses a particular problem. > >I have to get one field of information from an accounting package > >through ODBC. I have tried creating a view to include this info, but > >the ODBC driver is so extremely slow, (this is not an Rbase problem) > >it makes the file creation time unrealistic. Also, I have not figured out > >how to turn off the column headings in the export file. (I tried Set Head > >Off, but that did not accomplish the task) > > > >I can create a report, and use a lookup variable to the ODBC table and > >the speed is fine! (Evidently, their ODBC driver does not handle views > >very well. I did insure my linking columns where properly keyed) > >However, while reports give me much more flexibility in creating > >a data file, it does not have a CSV output format. > > > >Any ideas would be appreciated. > > > >Thanks, > >-Bob > > > >Thompson Technology Consultants > >276 Chippewa > >LaPorte, IN 46350 > >219-324-2605 (Phone & Fax) > >219-363-7441 (Cell) > >http://ttc.inc.home.comcast.net > > Emmitt Dove > Manager, DairyPak Business Systems > Blue Ridge Paper Products, Inc. > 40 Lindeman Drive > Trumbull, CT 06611 > (203) 673-2231 > [EMAIL PROTECTED] > [EMAIL PROTECTED] >
