Hi all,
I am trying to remove some keywords based on the value of another column.
What I am hoping to achieve:
Removing Oxley & Victoria in Column A
Can anyone please provide some assistance.
Thanks
Solved
Removing keyword based on the value of another column
+2- Contributor
Best answer by gav
Hi @calvin.fme - If you know the formatting will be consistent (for example, only 1 space after the value in Column B), 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.
+10- Contributor
- Best Answer
Hi @calvin.fme - If you know the formatting will be consistent (for example, only 1 space after the value in Column B), 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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.