Check a field if its numeric or alphanumeric and have fixed characters

Saravanan13

Hello All,

I have a scenario where I need to check the below conditions:

1. Check if a field is numeric or alphanumeric ? -

If its alphanumeric then reject.

If its greater than 9 characters then reject.

If its numeric and contain 9 digits then proceed else reject

If the field is null then proceed.

Digits check.xlsx

Data Investigation

Accepted answers

caltang

You can combine them all into 1 if you'd like. But I've split them up so you can see the logic of each process better. Hope this helps!

FinnCharlton

Hi @Saravanan13 , this formula will do that for you:

Proceed or Reject.yxmd

All comments

caltang

Your last statement seems to be the only things that matter. You can use a filter tool to do this:

There is a built in IS NOT or IS Null function. Hope this helps!

Saravanan13

I need to check all the below conditions in one formula

1. Check if a field is numeric or alphanumeric ? -

2. If its alphanumeric then reject.

3. If its greater than 9 characters then reject.

4.If its numeric and contain 9 digits then proceed else reject

5.If the field is null then proceed.

caltang

I've attached a workflow for you to further check.

Check Alphanumeric:

IF REGEX_CountMatches([data], '[a-z]')>0 AND REGEX_CountMatches([data], '[0-9]')>0
THEN 1
ELSE 0
ENDIF

Check Length:

IF LENGTH([data]) > 9
THEN 1
ELSE 0
ENDIF

Check Numeric:

IF IsNumber([data])
THEN 1
ELSE 0
ENDIF

Sample.yxzp

caltang

You can combine them all into 1 if you'd like. But I've split them up so you can see the logic of each process better. Hope this helps!

FinnCharlton

Hi @Saravanan13 , this formula will do that for you:

Proceed or Reject.yxmd

Saravanan13

Thank you so much

Saravanan13

Thank you

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335