I have a dataframe that has 10 columns, and I want to extract a particular string from one column and store it in another column.
The column looks like:-
BY INST 751569 : MICR CLG (CTS)
BY INST 4692 : MICR CLG (CTS)
IMPS/P2A/108711200632/XXXXXXXXXX2155/sector103
REJECT:187002:FUNDS INSUFFICIENT
NEFT-CITIN21233180661-VISHAL
I want to extract the following into another column
751569
4692
108711200632
187002
CITIN21233180661
How it can be done?