FIELD IDENTIFER WITH LETTER AND NUMBER CHARACTERS

[dunkindonut7777]

Hi I would like to ask if how can I separately identify these codes through creating another column. I would like to identify as "E" the id codes that contain numbers only while the codes that have letters plus numbers will be identified as "L". I would just like to add another column named "IDENTIFIER". Kindly see table below for the expected output.

ID	IDENTIFER
6435474	E
1074858	E
AB566889	L
C48755CD	L

can you help me with this one pls? thank you

[atcodedog05 · Accepted solution]

Hi @dunkindonut7777 

Here is how you can do it using regex match \d+ matches only number ids.

Workflow:

Hope this helps : )

[AngelosPachis]

Hey @dunkindonut7777 ,

You can make use of the REGEX MATCH function of the formula tool. What this function does is it checks your records against an expression pattern.

If you records only contain numbers, so the pattern will match the expression \d+, which stands for "one or more digits".

If your records contain numbers and letters of the alphabet, then your expression should change to \w+, which stands for "one or more alphanumeric characters".

If something falls out of that description, you can null the value of that record just to flag it.

Hope that helps,

Angelos

[dunkindonut7777]

THANK U FOR THIS!

[dunkindonut7777]

THANK U FOR THIS IT WORKS!

[atcodedog05]

Happy to help : ) @dunkindonut7777 

Cheers and have a nice day!