decimals and oracle

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicolas Cage - 29 Feb 2008 18:48 GMT

sometimes from a query of oracle i get an excel report with funny numbers
in text format like "100.000,00" instead of "100.000,00"

Oracle admin says Oracle spoil many times the data and i need to correct it
by code
Any idea?

Tia

Reply to this Message

Joel - 29 Feb 2008 22:26 GMT

Sub test()

MyNumber = "100.000,00"
location_period = InStr(MyNumber, ".")
location_comma = InStr(MyNumber, ",")
If location_comma > location_period Then
MyNumber = Replace(MyNumber, ".", ";")
MyNumber = Replace(MyNumber, ",", ".")
MyNumber = Replace(MyNumber, ";", ",")

End If

End Sub

> sometimes from a query of oracle i get an excel report with funny numbers
> in text format like "100.000,00" instead of "100.000,00"
[quoted text clipped - 4 lines]
>
> Tia

Reply to this Message

Nicolas Cage - 01 Mar 2008 10:55 GMT

> Sub test()
>
[quoted text clipped - 7 lines]
>
> End If

Not correct, if number is "100,000,00" ?

Reply to this Message

Joel - 01 Mar 2008 20:12 GMT

The new code will work under ANY case. I originally solved the problem as
you posted it.

> > Sub test()
> >
[quoted text clipped - 9 lines]
> >
> Not correct, if number is "100,000,00" ?

Reply to this Message