Extract Student number

44 views Asked by At

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" )

1

There are 1 answers

0
Widhold On BEST ANSWER

This should work:

/\bIMIS\/C\/\d+\/\d+\/\d+\/\d+\/\d+\b/gm

Try it here: regex101