RegEx Tool

[Sclifton1098]

Hi all, 

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

Thank you,

Stephanie

[OllieClarke · Accepted solution]

Hi @Sclifton1098,

You don't need RegEx to do this (at least not based on your screenshot). @Luke_C has provided a solution for a filter tool

[Luke_C · Accepted solution]

Hi @Sclifton1098 

The regex tool cannot remove records from the workflow. You could use a regex_match function in a filter tool if regex is required, although that's not the ideal solution (regex uses more memory, so when a simple string function can be used that's better).

!Regex_Match([Details],'PettyCash.*')

[Sclifton1098]

Thank you all very much! I will stick with the filter tool.

[Sclifton1098]

Hi Luke! Is there a way to move all of the petty cash accounts from the detail column to a new column with the Regex tool?

[Luke_C]

Hi @Sclifton1098 

What do you mean by 'move' them? Just the descriptions in a new column? The amounts as well? Can you post the data (not a screenshot) along with your desired outcome? 

[Sclifton1098]

Yes I believe the objective is to move the Petty Cash account to a new column 

[Sclifton1098]

I believe the assignment is asking to Parse the data that is Petty Cash to a new column to exlude it

[Luke_C · Accepted solution]

Hi @Sclifton1098 

The same function I listed above can be leveraged in a regex tool set to match mode. It will result in a true/false column that you can then filter. Again this is not the most efficient way but understand you have an assignment. I'd suggest reading the below post, and don't forget to mark helpful replies as solutions. 

https://community.alteryx.com/t5/Alteryx-Community-Resources/Posting-for-Fastest-Possible-Solution/t...

[Sclifton1098]

Thank you for your help! I have to use the parse output method

[Luke_C]

Maybe the ask is to parse the check numbers? That would make more sense. Again posting the actual data and expected results will yield you much better quality responses. Most folks would prefer not to have to re-type data based on screenshots.