Comma as a separator in Italian Euro format

fabio natali <[email protected]> Sat, 1 Mar 2008 13:38:38 +0100
Newsgroups gmane.comp.db.mdb-tools.devel
Message-ID <[email protected]>
Hi Everybody!

I'm having problems while using mdb-export against one of my
databases.

This is what I get:

user@host$ mdb-export -d"\t" test.mdb euro_table
FIELD0	EURO_VALUE
0	00000000696.
1	00000004000.
2	00000008133.
3	00000000800.

while the following output was expected:

FIELD0	EURO_VALUE
0	696,56
1	4000,34
2	8133,44
3	800,40

or

FIELD0	EURO_VALUE
0	696.56
1	4000.34
2	8133.44
3	800.40

This db has been made with Access using Italian localization. The
following notation for Euro currency is used:

450,75

instead of

450.75

Maybe this is the problem?

Any hints to handle this?

Kind Regards,

-- 
fabio natali


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/