Regex: Remove unwanted expressions

[BautistaC888]

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

[DawnDuong]

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 

[BautistaC888]

Yes,

- All alphabets.
- And dd.mm.yy expressions.

[BautistaC888]

Yes,

- Remove all that contains alphabets.
- and expressions with formats dd.mm.yy

Thank you

[BautistaC888 · Accepted solution]

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.

[Maskell_Rascal · Accepted solution]

Hey @BautistaC888 

This formula will work for you. 

ToNumber(REGEX_Replace([Exempted], '(\d{2}\.\d{2}\.\d{2})|([a-zA-Z])', '0'))

Cheers!

Phil