I have a text column which I want to number and increment based on a condition. For example : where ever word "Finished' appears in text column just increment the number.
Sample dataset
| Text column |
| started running uefhrgfge |
| absdbd |
| jadhuesahd |
| ejuh3w |
| eurwe |
| finished feuihref |
| Started running swhdwe |
| dfiogehr |
| rgj |
| rejgir |
| rgmjoeg |
| finished swhdwe |
Desired output
