FIELD IDENTIFER WITH LETTER AND NUMBER CHARACTERS

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

Adobe

Accepted answers

atcodedog05

Hi @dunkindonut7777

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

Workflow:

Hope this helps : )

identify.yxmd

All comments

atcodedog05

Hi @dunkindonut7777

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

Workflow:

Hope this helps : )

identify.yxmd

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

example.yxmd

dunkindonut7777

THANK U FOR THIS!

dunkindonut7777

THANK U FOR THIS IT WORKS!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703