Checking for numeric or alpha values

[Former Member]

Hi,

I can't seem to find a way to find out if a field contains a numeric value. Is there anything within standard mapping that would allow me to do that?

Many thanks

[Former Member · Accepted solution]

Hi,

you are right that there is no standard function.

But you could use a simple UDF (with parameter a 😞

>int i = 0;

>try {

>i = Integer.parseInt (a);

>} catch (Exception E){

>return "0";

>}

>return "1";

Regards

Patrick

[Former Member · Accepted solution]

Thanks - it's working.