I was only able to succeed by starting RBase and at the R Prompt do: set var vc = (char(28))
then Write .vc In the output pane, there is going to be a square dot, Select it so it is highlighted, then copy it to clipboard (ctrl-c), then go to control panel to the regional settings where you set your list separator, and clear the existing one and paste the clipboard to it and select "Apply". I can check the results on my machine because my text editor displays these characters properly and I have affirmed that the copied character is the correct one. BTW, I used RBase as the source cause I knew you had that as a source and perhaps not a text editor. HTH. ----- Original Message ----- From: "Paula Stuart" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> 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] > > >
