cancel
Showing results for
Did you mean:
Helper I

## Extract 8 digit number from column contains text and number

Need help to get the 8 digit number from the given column, thanks.

 ABC- AB12345-12345678-AB 12345678 12345678 12345678 123456 T12345678 12345678 given column extract 8 digit number

1 ACCEPTED SOLUTION
Solution Sage
6 REPLIES 6
Solution Sage

so it will be right!

Solution Sage

Solution Sage

Helper I

i have a new problem

the numbers seperated by the text or delimiter were merged to form the 8 digit number, and i don't want this to happen

DATA                                                what I have what I need

 ABC- AB12345-12345678-AB 12345678 12345678 ABS-12345678-ABV 12345678 12345678 Abd=IUY=BGTYH-AI789_12345678 12345678 12345678 T12345678-12345 12345678 12345678 Abx-ABC23456789-12345678 12345678 12345678 ABA1234HDSC8765 12348765 BGS-123-45678 12345678 bsg-123-12345678 12345678 12345678 BFH-12345678-123 12345678 12345678
Resolver I

In power quey,click that column and there is option available called split column to extract the numbers from text.

Thanks,

GS

Helper I
 ABC- AB12345-12345678-AB 12345678 12345678 ABS-12345678-ABV ABV 12345678 Abd=IUY=BGTYH-AI789_12345678 AI789 T12345678-12345 12345 12345678 given column By splitting extract 8 digit number what I have what I need