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 lettersI give you a workflow as an example.Thank you
I found a way to eliminate the dates using the datetime tool and an if formula. There must be a better way to do it, but its what i can do as a novice. 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
Hi @BautistaC888
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.yyThank you
