Extract 8 digit number from column contains text and number

[Yqy]

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

[Ahmedx]

so it will be right!

[Ahmedx]

[Ahmedx · Accepted solution]

[Yqy]

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

[Gowtham_Selvam]

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

If I answered your question,kindly mark it as solution.

Thanks,

GS

[Yqy]

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