Remove unwanted expressions

[BautistaC888]

Hello,

I have to clean up a .txt and i need to remove unwanted expressions.
I need to remove all expressions that contains characters and expressions like dd.dd.dd
Here is an example,
Input:

Expected output:

Thank you.

[DawnDuong]

Hi @BautistaC888 

One way is to use the regex match. The regex syntax can be something like this

.*[^0-9].*||\d\d\.\d\d.\d\d

https://help.alteryx.com/current/designer/regex-tool

1. • Match: Append a column containing a number: 1 if the expression matched, 0 if it did not.
     • Column name for match status: Provide a name for the appended column.
     • Error if not Matched: Select to generate an error if the expression and string do not match to end the workflow processing.

[PedrodeOl]

Hi @BautistaC888,

Use the regex match function in formula:

([0-9.,]+) = get the your figures

(\d{2}\.\d{2}\.\d{2}) = remove the pattern dd.dd.dd

regards,

[apathetichell · Accepted solution]

In formula tool:

REGEX_Replace([Exempted],"([a-z\s]+|\d{2}\.\d{2}\.\d{2})","")

See attached where I wrap it in a multi-field formula and convert your field to a number format... Do you need visible commas?