Check for Numbers

[#1]

Hi All,

I have a field with 0043-APT-XYZ-DW.

The first 4 elements shows the project name.

How to check whether the first 4 elements are number?

Regards,

Keerthi KS

[tresesco · Accepted solution]

IsNum(Left(YourField,4))

or,

IsNum(SubField(YourField,'-',1))

[avinashelite]

try like this using subfield function :

IsNum(SubField(FieldName,'-',1))

[Kushal_Chawda]

if( isnum(subfield(Field,'-',1)), expression1, expression)