Remove unwanted expressions

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.

remove unwanted expressions.yxmd

Regex

Preparation

Accepted answers

apathetichell

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?

remove unwated expressions - 6 29 2021.yxmd

All comments

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

- 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.

pvoliveira

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

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?

remove unwated expressions - 6 29 2021.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703