decimals and oracle

  • Thread starter Thread starter Nicolas Cage
  • Start date Start date
N

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
 
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
 
Joel said:
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
Click to expand...
Not correct, if number is "100,000,00" ?
 
The new code will work under ANY case. I originally solved the problem as
you posted it.
 
Back
Top