Field should be alphabetic. It should not be numeric. How to check this validation?
Solved! Go to Solution.
use field summary tool under data investigation pallet.
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.
Just add for specify space also:
.*[0-9|\W|\s].*
I tried. But its not working. Can you please update me.
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
Great . Thank you very much for your help .
Another potential regex solution:
use a filter:
Regex_countmatches([field],"\d") = 0
that looks for no numbers
cheers,
mark