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
- 4 replies
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+10- Contributor
- 11 replies
- 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.