Christian It used to that way a few years ago, but nowdays you can keep the delimiter as comma. I glad you find a solution.
Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För christian hjortmar Skickat: den 11 juni 2009 20:20 Till: RBASE-L Mailing List Ämne: [RBASE-L] - SV: gateway export and Specification_file_name Thank you, Gunnar! Your tip worked :=) Changing CURRENCY format to 2C was the trick. You see, I thought one had to change delimiter too if you change currency format between A,B,C. Because it would upset Rbase:s calculations. Not so anymore. You have all given my evening a pleasant glimmer. My best to all of you Christian Hjortmar ----- Original Message ----- From: Gunnar Ekblad <mailto:[email protected]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Wednesday, June 10, 2009 8:23 PM Subject: [RBASE-L] - SV: gateway export and Specification_file_name Christian I have tried to find a solution the way you asked for. I did not manage, maybee I was slow on my last razzak training!?, It might be there but I did not find it. However if you revrse the the issue, create an excelshett with predefinde columns with formats and then do an ODBC inquriy you should be able to achive what you want! Let me add I am happy to see user from sweden that I was not aware about. Dont heisitate to answer privatly if yo you have an issue with my reply! Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För christian hjortmar Skickat: den 5 juni 2009 21:04 Till: RBASE-L Mailing List Ämne: [RBASE-L] - gateway export and Specification_file_name Hi, all! When exporting to an excel sheet from GATEWAY. Is it posssible to specify the format of the target column within the SPECIFICATION_FILE_NAME option? I.e. an price column in excel should have 2 decimals. Thankyou Christian
