I'm new to KNIME and I wanted to search inside .xls data for a certain word. In the excel table I have a column with text and inside of that text I want to find out the position of a certain word, by using the String Manipulation Node like that:
indexOf($Text$,"word" ,"w" )
Now I get a new column where the index of the word is shown, or the number "-1" if the word is not existing in the text. The problem is that I want to find all indices and not only the first. So if the word of interest is existing more than once, I also want to get the other positions.
Is there a possibility to use the String Manipulation Node for that problem, or do I have to take another node?
Thanks for your help