Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

Reply
Yqy
Helper I
Helper I

Extract 8 digit number from column contains text and number

‎03-08-2023 10:34 PM

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

 

Labels:
Message 1 of 7
4,054 Views
0
1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

‎03-08-2023 11:12 PM

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

View solution in original post

Message 4 of 7
3,994 Views
6 REPLIES 6
Ahmedx
Super User
Super User

‎03-09-2023 12:35 AM

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

Message 7 of 7
3,959 Views
0
Ahmedx
Super User
Super User

‎03-09-2023 12:27 AM

Screen Capture #460.png

Message 6 of 7
3,969 Views
0
Ahmedx
Super User
Super User

‎03-08-2023 11:12 PM

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

Message 4 of 7
3,995 Views
Yqy
Helper I
Helper I
In response to Ahmedx

‎03-08-2023 11:57 PM

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
Message 5 of 7
3,978 Views
0
Gowtham_Selvam
Resolver I
Resolver I

‎03-08-2023 10:51 PM

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

Message 2 of 7
4,035 Views
0
Yqy
Helper I
Helper I
In response to Gowtham_Selvam

‎03-08-2023 11:00 PM
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 
Message 3 of 7
4,004 Views
0

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

View All