converting string values to numeric

[Atlas]

I have situation where I am receiving data from a spreadsheet where the numeric data is received as a character string Example 1,884.44

When I try to convert to numeric string I end up with a value of 1. I have tried different functions and still get the same result. All I want to do is save this number as a rounded numeric value ie: 1884.

I would appreciate any help.

Thanks

Atlas

 

[lordhawkins]

Try this

VAL(strtran("1,234.56",",",""))

 

[JRB-Bldr]

A slight modification to the above...

mcNumber = "1,234.56"

* --- Remove Comma's From Char String ---
mcNumber = STRTRAN(mcNumber,",","") 

* --- Convert Char to Number ---
mnNumber = VAL(mcNumber)

* --- Or Convert Char to RoundUp Number ---
mnRndNumber = INT(VAL(mcNumber) + 0.5)

Good Luck,
JRB-Bldr

 

[torturedmind]

a one-line variation of the above:

? VAL(STRTRAN(mcNumber, ",", ""))

i hope this helps. peace!

kilroy
philippines

"Illegitimis non carborundum!"

 

[baltman]

Don't know about the performance difference, but the one character replacement function is CHRTRAN().

Brian

 

[craigsboyd]

Atlas,
Given that you said you wanted the value rounded I would use:

ROUND(VAL(CHRTRAN("1,844.3",",","")),0)

torturedmind
I don't see where your suggestion is different than the one lordhawkins made

baltman
There is indeed a performance difference in favor of chrtran()...even putting strtran() second in the test so it perhaps picks up some benefit from cache it is shown to be slower than chrtran()

lnStartSeconds = SECONDS()
FOR lnCounter = 1 TO 1000000
	ROUND(VAL(CHRTRAN("1,844.3",",","")),0)
ENDFOR
?SECONDS() - lnStartSeconds

lnStartSeconds = SECONDS()
FOR lnCounter = 1 TO 1000000
	ROUND(VAL(STRTRAN("1,844.3",",","")),0)
ENDFOR
?SECONDS() - lnStartSeconds

http://www.sweetpotatosoftware.com