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?