Cleansing data with different languages

Hi all,

I am trying to cleanse company name from different countries, I would like to give abbrevations for term like incorporation to INC and Limited to LTD (english ) and now if german company then Gesellschaft mit beschränkter Haftung to GMBH etc., I have a lookup table for all those abbrevations and a field showing the language. 

How could i choose the language before in knime , so that only those langiuage scripts get executed from the look up table to the dataset. 

 

I would also appreciate , if you could suggest me any other simpler method . Thanks !

 

 

Hey dannychristy,

there are two really nice examples in another thread: https://www.knime.com/forum/knime-general/how-to-add-more-than-one-expression-in-string-manipulation. You should be able to adapt their example-workflows for your specific problem. Hope that helps.

Cheers,
Marten