Field should be alphabetic. It should not be numeric. How to check this validation?

[manojkumar123]

Field should be alphabetic. It should not be numeric. How to check this validation?

[ashissanpui]

use field summary tool under data investigation pallet.

[vishwa_0308]

You can use regex to check for only alphabets or any other patterns you are looking into field(s).

For now, you can use the following pattern using regex tool and matching method for your needful:

.*[0-9|\W].*

This will create a new field with True/False basis criteria.

[manojkumar123]

Hi,@vishwa_0308

For First Name - "Manoj Kumar" , it is valid value. It gives

[vishwa_0308]

Just add for specify space also:

.*[0-9|\W|\s].*

[manojkumar123]

I tried. But its not working. Can you please update me.

[afv2688 · Accepted solution]

Hello @manojkumar123,

Lets try with brute force lol

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[manojkumar123]

Great . Thank you very much for your help .

[MarqueeCrew]

Another potential regex solution:

use a filter:  

Regex_countmatches([field],"\d") = 0

 that looks for no  numbers

 cheers,

 mark