Newb in KNIME - FIND, EXTRACT AND PUT IN A NEW COLUMN specific words in a cell

Hello, KNIME Newb here. I am transposing a formula in excel and migrating to kKNIMEnime. Below is the screenshot of my formula which basically, looks upon specific words in a Column containing long sentences.

Questions:

  1. Nodes/Combination needed to migrate it to Knime
  2. I also need to follow the below hierarchy:

I appreciate your help.
Thanks, Maribeth

The “LIKE” function of the Rule Engine node will help you accomplish this.
Just create a rule for each keyword search, and list them in the order in which you want them applied.
An example rule would be:

$GL Journal Line Description$ LIKE "*Proquest*" => "Proquest"

3 Likes

Thank you very much! IT WORKED! :slight_smile: :grinning:

1 Like

Hi there @MARIBETHQUINONERO,

welcome to KNIME Community!

In case you have many rules you might want to check Rule Engine (Dictionary) node. Also what can help you is free From Excel to KNIME book KNIME offers. You will find it on following page together with other books https://www.knime.com/knimepress

Br,
Ivan

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.