True/False If a Field Contains a Letter

Hi,

I want to create a new column at the end of my existing input data that determines if a field containing numeric values has a letter somewhere in the value. Is it possible to have this new column populated by true/false values? True, if the existing numeric value contains a letter somewhere in it. False if the existing numeric value does not contain a letter somewhere in it.

The field is an identification number. Not sure why some of them contains numbers and letters but they shouldn't.

Thank you!

Tips and Tricks

Accepted answers

patrick_digan

@Dyl_A You could use a formula tool to define a new field with this sort of formula:

IIF(REGEX_CountMatches([Field1],"[[:alpha:]]")>0,"True","False")

That seemed to work on my end.

All comments

patrick_digan

@Dyl_A You could use a formula tool to define a new field with this sort of formula:

IIF(REGEX_CountMatches([Field1],"[[:alpha:]]")>0,"True","False")

That seemed to work on my end.

Dyl_A

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703