How to check if the field begins with number or alphabets

[Former Member]

Hello Experts,

I have a requirement where in the filed will contain alphanumeric value and I must map based on whether the field starts with alphabet or number.

I know I have to use Starts with function ,but how do I check whether the field begins with number or alphabet.

Thanks in advance

Regards

Advit

[engswee · Accepted solution]

Hi Advit

You can use the following single value UDF to check if the first character is numeric or not

if(Character.isDigit(input.charAt(0))) {
return "true";
} else {
return "false";
}

Rgds

Eng Swee

[Former Member · Accepted solution]

Thanks Eng Swee