I have excel data which contains many columns, one column called Description has the following data, I want to extract student number from each row using KNIME
Example below are three different rows
Being Settlement of exam fee, student Number IMIS/C/5946/7/5/2021/5690 in respect of Flora Hamis
Being Settlement of school fee, student Number IMIS/C/28727/14/7/2022/28980 in respect of Tony Alex
Being Settlement of Life Assurance, student Number IMIS/C/28020/23/6/2022/28279 in respect of Richard Nixon
Here is my attempt
regexReplace($Description$,^IMIS/\w{1}/\d/\d/\d/\d\s? ,"$1" )
This should work:
Try it here: regex101