Dick, You can:
Unload data from tablename as csv That will eliminate the quotes and the currency format. Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Tuesday, June 08, 2010 3:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - SET CURRENCY While we are working toward a switch to Extreme 9.0, we are still operating in 7.5. State has decided we must file sales tax on-line, but we can upload as a CSV file. Quite easy to create using Gateway Export. However... Using SET CURRENCY ' ' PREF 2 D Gets rid of the $ in the output, gets rid of the comma between thousands, but the decimal becomes a comma. Help indicates it should be a period. In addition, is it possible to eliminate the double quote marks around each item? They recommend saving to an Excel file, then exporting as CSV. Results are exactly the same as exporting directly from R:Base. Dick Fey Carpet Broker Inc.
