I have situation as mentioned below. I want to extract isnumber from column 1 and put in column 2 as can seen in picture.
ikl;knkjnnn749000sk | 749000 |
ergheqrh550000sb | 550000 |
rg100erg0000rgh | 1000000 |
erger900000greh | 900000 |
erg600000rg | 600000 |
5erger00000ergerg | 500000 |
fgb80000gg0rff | 800000 |
fgwe6ewfgw1gweg | 61 |
g50000f0w | 500000 |
wef3wef1330weg | 31330 |
gwe2300000 | 2300000 |
800000ewgweg | 800000 |
egwweg13000wegwe00 | 1300000 |
sdg13636ghj | 13636.36 |
36000sd | 36000 |
sdg500000 | 500000 |
sdgsdg52500 | 52500 |