community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

FIND REPLACE KEEP AND REMOVE STRINGS

Atom

I am looking for a solution that will identify if the From Column contains the value in the To Column and then removes those string characters.  Please see the example below. The fourth column is the outcome I am looking for.  Does anyone know who to write this formula? 

Alteryx Partner

Hi @JaMon 

 

I have created a workflow for you which does this.

 

It is a series of 3 formulas in the 1 formula tool which replaces specific parts of the string with characters with the REGEX_REPLACE expression.

 

Hope this helps you!

 

- Andrew

Labels