I need a Regex to remove unwanted expressions from a document.
There are two unwanted expressions for example:
- "30.03.21"
- or any expression that contains letters
I give you a workflow as an example.
Thank you
Solved! Go to Solution.
Do you mean that you want to remove from a string 1) all alphabets and 2) anything that has the pattern like dd,mm.yy format?
Dawn
Yes,
- All alphabets.
- And dd.mm.yy expressions.
Yes,
- Remove all that contains alphabets.
- and expressions with formats dd.mm.yy
Thank you
Hey @BautistaC888
This formula will work for you.
ToNumber(REGEX_Replace([Exempted], '(\d{2}\.\d{2}\.\d{2})|([a-zA-Z])', '0'))
Cheers!
Phil