Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Yqy
Helper I
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
Ahmedx
Super User
Super User

6 REPLIES 6
Ahmedx
Super User
Super User

so it will be right!
Screen Capture #461.png

Ahmedx
Super User
Super User

Screen Capture #460.png

Ahmedx
Super User
Super User

Screen Capture #457.pngScreen Capture #458.pngScreen Capture #459.png

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-AB1234567812345678
ABS-12345678-ABV1234567812345678
Abd=IUY=BGTYH-AI789_123456781234567812345678
T12345678-123451234567812345678
Abx-ABC23456789-123456781234567812345678
ABA1234HDSC876512348765 
BGS-123-4567812345678 
bsg-123-123456781234567812345678
BFH-12345678-1231234567812345678
Gowtham_Selvam
Resolver I
Resolver I

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

 

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

 

Thanks,

GS

ABC- AB12345-12345678-AB1234567812345678
ABS-12345678-ABVABV12345678
Abd=IUY=BGTYH-AI789_12345678AI789 
T12345678-123451234512345678
given columnBy splitting extract 8 digit number
 what I have what I need 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.