Forums » General Discussion

Thread: Export via Export wizard lose formatting number

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 0 - Pages: 1
BartA

Posts: 2
Registered: 1/12/11
Export via Export wizard lose formatting number
Posted: Jan 12, 2011 8:09 AM
 
  Click to reply to this thread Reply

I have Toad 4.6.0.531
I have an English version of Windows 7
My language and country settings are Dutch Belgium (on Windows)
In Belgium we use , as a decimal seperator.

When I have a decimal. I see in the Grid the formatting correct.
When I export via the wizard -> 'comma seperated values' he exports the decimal with a point instead of with a comma.

Small test that you can do:
select 5/10;
The result the toad grid is (correct):
"5/10"
0,5

Right click -> export -> Export wizard -> next -> next -> finish
and the result is (incorrect):
"5/10"
0.5


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums