Solved

Removing keyword based on the value of another column

C

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

icon

Best answer by gav 25 July 2022, 03:25

View original

3 replies

gav
Rank
Badge +3

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.

 

StringReplacer - Replace Text

Check out more FME-related content on Youtube: https://www.youtube.com/playlist?list=PL82P_nlkz8Yhx-_1cgN3Ji92I5waGxFsy
C

Thank you so much @gav​. It worked!  

gav
Rank
Badge +3

Rock on!

Check out more FME-related content on Youtube: https://www.youtube.com/playlist?list=PL82P_nlkz8Yhx-_1cgN3Ji92I5waGxFsy

Reply


Community Stats

28,670
Posts
109,365
Replies
36,531
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.