Extracting a Number with a forward slash to a new column
Hi,
I am very new to knime.
I have been working a workflow and I am stuck trying to extract a number from text.
The problem is in a particular column, I have text but in front of the text is always a date written in the form dd/mm.
E.g “24/04 Testing my Knime workflow”. The date however can be written in any form in situations where the day or month is singular i.e. “3/3” or “09/3” or “9/03”.
I want to extract this number - in the case of my example “23/03” into a new column by itself.
Now I am not really interested in the string. I Just want a function that reads that column and extracts the number in front of the string into a new column.
Please can anyone offer any help as regards this?
Thank you.