Don't fiddle with the currency settings, too dangerous, as expressed by Karen.
You could prepare your data in a temp table first before exporting. try a text column and update it with something like: update table tablename set CurrText = (FORMAT(currencycolumn,'999999990.00')) Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Thursday, October 10, 2013 9:30 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]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[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
