Extract consecutive 8 digit number from column contains text & number

[Yqy]

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

[danextian]

Hi @Yqy ,

Please  try the script below. What it does it converts the  text string into  a list, converts the items into a number if can be else null, then filters the list to exclude null, converts the list back into a text string, extracts the first  8 characters only then convert it back to  number.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcnRy1lVwdDI0MjYx1QWTZuYWuo5OSrE6IMlgZLEwiGBSiq1naKStk3tIpIeuo6e5hWU8TBFYQQhcC5gB1VQBNMAZKmGpi6LB0ckRxPdwCXa2MDeDaHByB1uti1CVVJwOFkHR6uTmoYtsnVJsLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [DATA = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Convert to List", each Text.ToList([DATA])),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Get Number", each List.Transform([Convert to List], each try Number.From(_) otherwise null)),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Filter List", each List.Select([Get Number], each _ <> null)),
    #"Extracted Values" = Table.TransformColumns(#"Added Custom2", {"Filter List", each Text.Combine(List.Transform(_, Text.From)), type text}),
    #"Added Custom3" = Table.AddColumn(#"Extracted Values", "First8", each Number.From(Text.Start([Filter List],8)), Int64.Type)
in
    #"Added Custom3"