MessagePaula, You can use SRPL to replace the comma with (char(28)). Look in help under 'ascii chart' for the full chart of ascii characters. R>set var vlist = 'item1,item2,item3'
R>set var vnewlist = (srpl(.vlist,',',(char(28)),0)) R>SHO VAR VNEWLIST item1 item2 item3 RBase understands the ascii character codes, so you could change your DELIMITer before you export your data. I don't like to do that in a multi user environment...but it's possible. Just don't forget to change it back to ',' when you're done. set delimit = (char(28)) Dawn ----- Original Message ----- From: Paula Stuart To: RBASE-L Mailing List Sent: Monday, January 21, 2008 5:49 PM Subject: [RBASE-L] - Help! 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]
