RegEx Tool

[Sclifton1098]

Hi all, 

I need some assistance removing a word from a column using the Regex tool?

Thank you,

Stephanie

[Luke_C]

Hi @Sclifton1098 

Can you post a sample of the data? 

[IraWatt]

Hey @Sclifton1098,

Would you be able to give a couple examples of the text and the word you want to extract? If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...

[Sclifton1098]

Hi all, 

Below is a screenshot of what the assignment is asking. I have to remorve the PettyCash from the detail column to expense those accounts.

Thank you!

[DataNath]

@Sclifton1098 if you just need to remove 'a word' rather than a certain pattern, would a regular string function like Replace() not suffice? Here we want to remove the word 'please' and so we just replace it with nothing:

[Sclifton1098]

Hi all, 

Below is the data.

[Luke_C]

@Sclifton1098 

The description and link in your image make me think a filter tool is more appropriate, however without seeing the actual data the ask is still unclear

[Luke_C · Accepted solution]

Hi @Sclifton1098 Are you looking to remove the PettyCash entries? I presume they would not be capitalized.

You could use a filter tool with a statement like: !Startswith([Detail],"PettyCash")

[Sclifton1098]

We are trying to exclude the data that is petty Cash amounts that are in the detail column, we are trying to remove those rows. 

[Sclifton1098]

Thank you! My professor is requiring the use of Regex tool.