SQLLoader : decimal with . or ,

From: Olivier ERTZ <ertz_at_illite.u-strasbg.fr>
Date: Tue, 05 May 1998 16:36:55 +0200
Message-ID: <354F2407.283A5D39_at_illite.u-strasbg.fr>



Hello,

[Quoted]     i have a text file (in fact a .csv from Excel) with decimal number     like 54.65 and not 54,65.
    sqlloader seems to make a difference between the point and the comma

    with the comma, it works
    with the point, it doesn't work, but i want to load files with points

    is there a solution that permits to load decimal point formed ?

    Thank you for answering

--
------------------------------  ERTZ Olivier  -------------------------
 Etudiant en Maîtrise Informatique  |     Vacataire du CGS - EOST
UFR de Mathematique et Informatique | Centre de Géochimie de la Surface
    67000 STRASBOURG - FRANCE       | 1, rue Blessig - 67084 Strasbourg

--> ertz_at_pascal.u-strasbg.fr <-- | --> ertz_at_illite.u-strasbg.fr <--
----------------------------------------------------------------------- ...zORgLUb \|/ ____ \|/ _at_~/ ,. \~@ /_( \ _/ )_\ la revanche... \_U__/
Received on Tue May 05 1998 - 16:36:55 CEST

Original text of this message