Checking for numeric or alpha values

This question is answered

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

Correct Answer

September 23, 2008 at 14:34 PM

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

0 Likes 0 View this answer in context