Hi All,
I have a comments column and in that I have service number and along with some comments and dates. In that I have to strip only service number. service numbers are mostly having 8 digits but few cases service numbers are 7 and 9 digits.
sample data posted below, help me out how I can extract only numbers(highlighted red color) from a given column.
| Comments |
| DLL DISC / 02.09.2021/ 30364307/abc |
| LEASE DISC / 11.23.2020/10117134/def |
| LEASE DISC / 11.23.2020/10127588/Integr |
| LEASE DISC / 10101466, 10143520 / ADFC |
| LEASE DISC / 10111445 / 80800005 |
| LEASE DISC / 10131743, 10149069 / not |
| LEASE DISC / 10133124/ 10146144 QUALITY |
| LEASE DISC / 10145033 / 10118692 / Comm |
| LEASE DISC / 10146155/10135854 / Avffd |
| LEASE DISC / 10147220/10104449 /kjkdj |
| LEASE DISC / 10147431, 10147394 / hdhdh |
| LEASE DISC / 30335157 / 1518833 hhdyyy |
| LEASE DISC /10104449, 10147220 RYETBDJ |
| LEASE DISC/10105402-10144528/TRHJDSNJ |
| LEASE DISC/10124511-10147275/HTHRJHJ |
| LEASE DISC/10143314-10144617/hdjhjdhk |
| PMC DISC / 10141863, 10147184 / kokoo |
| PMC DISC 91000010 /10141863/hhdj ddd |
| PMC DISC 91000010 /10145554/jjjdjd'sss |
| PMC/ADV MED HOMECARE/10131042 10144358 |
| PMC/DYNAMIC HEALTHCARE/10146887 10101760 |
| WIRE FEE / 08-26-2020/10106466/MEDICAL |
| WIRE FEE/03.26.2021/10141187/TG OXYGEN |
| 10100465 Lease Disc |
| 10101498 Lease Disc |
| 10101760 Lease Disc |
| 10123751 / hddyytr nnn |
| 10125787 Lease Disc |
| 10126312 /reed nhhd lllj |
| 10127600 Lease Disc |
| 10140316 Lease Disc |
| 10146887 Lease Disc |
| ACH / 10101498 / hhdjh jkeebeel |
| ACH 91000016/AUGUST PREFUND/REBATE |
| WIRE FEE/03.26.2021/955843261/TG OXYGEN |
| LEASE DISC / 1014368 / bvcded Consulting |
Thanks
