I tried to change the currency settings but came up with a new headache. I tried to change from:
SET CURRENCY $ PREF 2 B Example $1,234.56 TO: SET CURRENCY '' PREF 2 D Example 1234,56 For some reason it put a comma where the period was. So I used a SRPL function after that to change the comma to a period and now it is good. Thx Dan From: Karen Tellef Sent: Thursday, October 10, 2013 7:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: formatting data when using gateway to export Changing the currency settings at one workstation does not change it for everyone on the database. Just make sure you set it back to the default when you're done. Otherwise if you are the last one to disconnect, your currency setting will be saved as the default. Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, Oct 10, 2013 9:21 am Subject: [RBASE-L] - formatting data when using gateway to export Our bank wants the currency field in a csv to be: 12345.00 No commas or dollar signs. Also, cents must always be there as .00 even if there are none. I tried using real which takes care of the commas and dollar signs but I need to always have the cents. I cannot change the settings as that will change everyone's settings. I am thinking there is a way to format the text when I do the gateway export command.. TIA Dan Goldberg
