Test for Numeric Value

[Former Member]

Hi All,

Quick question! is there a way to test for Numeric value in the Graphical mapping?

Thank you in Advance,

Danny

[Shabarish_Nair · Accepted solution]

there is not standard function available. But you can write a small UDF with a logic of parseInt or parsedouble in it to check for a numeric value.

[Former Member · Accepted solution]

Hi,

Is there any class that i need to import to use parsedouble?

[Shabarish_Nair · Accepted solution]

no. you wouldnt need any class.

[Former Member · Accepted solution]

I am using the below function, but for some reason it does not work.

String mynum = “Test”;

Mynum = integer.parseInt(Mynum)

if (mynum == parseFloat(mynum)){

return “Numeric”;

}

else{

return “NonNumeric”;

}

Message was edited by:

Danny Molepo

[Former Member · Accepted solution]

Hi

There is no way to check for numeric characters in Graphical Mapping.You can use this UDF for the same.Also you need not import any class for this.

function IsNumeric(strString)

// check for valid numeric strings

{

var strValidChars = "0123456789.-";

var strChar;

var blnResult = true;

if (strString.length == 0) return false;

// test strString consists of valid characters listed above

for (i = 0; i < strString.length && blnResult == true; i++)

{

strChar = strString.charAt(i);

if (strValidChars.indexOf(strChar) == -1)

{

blnResult = false;

}

}

return blnResult;

}

Thanks

[Former Member · Accepted solution]

Hi

You can also modify the above code to suit your needs.

Thanks

[Former Member · Accepted solution]

Hi MK,

Its works like charm. Thank you all for the quick response.

Regards,

D

[prabhu_s2]

nope....but u can check if a value is alphanum by some Proprietary code in UDF