Contains digit regex

Hi,

I have a formula to tell me if a column contains a digit:

REGEX_Match([CODE], ".*\d+.*")

So i have codes such as "p3sf" so It contains digit. So it would be a true for codes with a digit. would be false for a code "abcd"

However I have 2 codes that shouldnt be "contained as a digit"

For example: salesforce.com - (00d300001g8w) should not be included in the contains digit. same with "invoice_consumer_ 962255191"

All but these codes of my are lower then 10 characters.

How can I alter my regex to exclude these 2 fields?

Thanks.

Custom Tools

Accepted answers

@wonka1234
We can use 0 and 1 for Boolean type data.

0417-wonka1234-r1.yxmd

All comments

please take a look at the workflow attached to see if my workflow can cater your problem.

Thank you

replace null and combine.yxmd

@faiqz Sorry your excel file does not work. Its more of a regex issue and identifying digits.

@wonka1234
What is the cretiria here?

Why salesforce.com - (00d300001g8w) can be as containing "digit"?

@faiqz
Maybe you uploaded the different workflow? 😂

I think my regex is recognizing the bracketed digits , which is correct givne the current regex. However I need a way to exclude it/. I want to exclude the "CODE" > 10 characters(or anything other logic you can think of).. but I want to keep my original regex as is for the determining digit or not as it seems to work good.

@wonka1234
Thank you for the quick reply.
If we can exclude any text that having length of greater than 10, then maybe something like.
Hope I understand you correctly. 😁

0417-wonka1234.yxmd

Thanks. However my formula is already a bool type.

Can you make this into a true false type of statement?

@wonka1234
We can use 0 and 1 for Boolean type data.

0417-wonka1234-r1.yxmd

Quick Links

Tags

This months top contributors