Search a string in a column ans extract the string and the numbers associated in the cells just n...
Hello Knime’s community !
I am a new user of Knime and I have some questions.
I have this excel table :
what I need : Retrieve the rows where the green cells contain numbers and place them in another Excel file as a table. Conserve the columns “Composants”, ” %Massique” and “Capacité Calorifique “ and the rows “Masse boîte Vide” et “masse de coulis”. (This acts as a filter on the table, removing rows with empty green cells.)
What node should I use for this manipulation of searching and extracting datas ?
Thank you for your help.🙂