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]
