Converting character to integer

[PrintNET]

I want to change a variable that is a numeric character/s to integer form. Also, is it possible to do this if there are spaces in the character string?

 

[Eguy]

PrintNET;

lcMyChar = " 87.2"
lnMyNumeric = INT(VAL(ALLTRIM(lcMyChar)))
? lnMyNumeric


Ed

Please let me know if the suggestion(s) I provide are helpful to you.
Sometimes you're the windshield... Sometimes you're the bug.

 

[Steve Bowman]

NOTE:

val() will convert number string to number

? val("82.5&quot
will return 82.5 as number

? int(val("82.5&quot)
will return 82 as the integer of 82.5

? val(alltrim(" 82.5&quot) will trim any leading and trailing spaces and return 82.5 as number

? val(alltrim(" 8 2.5&quot) will return 8 as number because val will stop at the first non-numeric char


? val(chrtran(" 8 2.5"," ","&quot) will transform all " "(spaces) to "" before the val


? val(chrtran(" 8 2.5"," ","&quot) would best handle spaces inside the number string not just before and after.


Steve Bowman
steve.bowman@ultraex.com

 

[Steve Bowman]

forgot if you also want the return to be just the intiger i.e 8 instead of 8.5 then

? int(val(chrtran(" 8 2.5"," ","&quot))


Steve Bowman
steve.bowman@ultraex.com