I really do love this list! Three replies in as many minutes. I'm actually creating the file by creating a table with the data in the format it's needed in (which involves converting date and currency fields into text for example). Then the program file gateways the table out to a csv file. I can certainly change the delimiter to (char(28)) as Dawn suggested. I just didn't know I could do that or how. This file gets transmitted to me from the network so I'm creating the file for importing to the FEC on a single user system. That may be the easiest thing to do. Then I could change it right back. Two hours looking around in all the wrong places...when I should have just come to this list where I got an answer in two minutes. Mike, your response came in as I was writing this, and I tried your suggestion and it also works. I was just hesitant to muck around in control panel because I understand that would change the delimiter for all programs. Of course I can change that back too, but I'm going to try to change the delimiter in Rbase and see how that works first, because it will only affect the delimiter for Rbase (which I'll also change back immediately also). Thanks to all of you! Now I not only have an answer....I have multiple ways to do this! And God Bless Rbase......there is ALWAYS an easier way to do things with this software! Paula Stuart Database Strategies 70 Summer Street Somerville, MA 02143 617-776-3367 617-776-4554 (Fax) 617-388-1331 (Cell) [EMAIL PROTECTED]
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, January 21, 2008 6:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Help! Paula, You do not state whether you are unloading data from a table or trying to create a file with a report. The process would be different. However, if a single user database. set var x = (Char(28)) set delimit = .x unload data for tablename as acii set delimit = , Should get your table data in a delimited with the Char 28 character as the delimiter. Note, that setting the delimit character is database wide, so in a multi user setting the above could pose problems. If multi user, the GATEWAY command has many options to do what is needed. Let us know more details if this is not what is needed. -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: "Paula Stuart" <[EMAIL PROTECTED]> OK, I'm losing my mind. I have a client who has to import data into a software package that's just been updated by he FEC. We've been sending a comma delimited file for years, which has worked fine. With the latest software update of their system, they now require that the delimiter be not a comma but an ASCII 28 character. Their instructions involve changing this by going to the Windows control panel and changing the list delimiter character there by "cutting and pasting" the character that my text editor uses for the ASCII 28. Well, I've tied in several different programs to see if I can get anything to print for this ASCII character. Using the ALT + typing the numeric value of the ASCII character works for ASCII values in the print range, but this is a control character......so the cursor just sits their blinking at me. What am I to "cut and paste?" Lots and lots of potential delimiters they could use and they select an invisible control character -- my government at work! I know that in Rbase there's a way to search for ASCII characters such as spaces -- but I can't immediately find those emails in my directory (something like (CHR(032)) I think). Is there a way to send out a delimited file from Rbase (or create a CSV file and then edit with the text editor) to replace the commas with ASCII? I've got a filing deadline this week and they just released the new version of the software last week. I've had the file reformatted for months in comma delimited form, but I can't figure out how to change the commas to an invisible control character. That requirement wasn't revealed until they released the software update last week....and I'm just now testing the import because my client just sent me the data file. I've been googling my brain out to no avail. Don't see anything in Rbase help either. I'm using version 7.1 if that makes a difference. Paula Stuart Database Strategies 70 Summer Street Somerville, MA 02143 617-776-3367 617-776-4554 (Fax) 617-388-1331 (Cell) [EMAIL PROTECTED]
