Hello, I have a situation where I need to remove business entity types from a list of customer names. I have a list of 195 of these words/abbreviations (i.e. Inc, Co, Corp, LLC).
In the String Manipulation node, I can choose Remove, but I prefer to use Replace because I have the ability to use modifiers which is critical. It would be nice if I could use Remove and still use modifiers but that doesn’t appear to be possible. I need to ensure only whole words are replaced and the case needs to be ignored.
My issue is that I can’t seem to enter multiple expressions. Here is a screen print of the expressions and the error.
What am I doing wrong? I have been reading the forum for hours now and have tried all of the other ways to do this that I have found, but nothing seems to work for me. I’ve only been using KNIME for a couple of weeks now and I have no previous experience with using tools like this.
Thank you for the assistance.
-Matt