decimals and oracle

[Nicolas Cage]

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

 

[Joel]

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

 

[Nicolas Cage]

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

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

 

[Joel]

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