Skip to main content
  • EN

Hi all,

 

I am trying to remove some keywords based on the value of another column.

 image 

What I am hoping to achieve:

Removing Oxley & Victoria in Column A

 

Can anyone please provide some assistance.

 

Thanks

Hi @calvin.fme​  - If you know the formatting will be consistent (for example, only 1 space after the value in Column 😎, you can use a StringReplacer and set the Attribute to "Column A", Mode to "Replace Text" and Text To Replace to "@Value(B) " (Don't forget the space). Screenshot below.

 

StringReplacer - Replace Text

Thank you so much @gav​. It worked!  

Rock on!

Reply


Community Stats

30,167
Posts
114,520
Replies
37,824
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.