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: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
3,081 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,021 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
2,986 Views
0
Ahmedx
Super User
Super User

‎03-09-2023 12:27 AM

Screen Capture #460.png

Message 6 of 7
2,996 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,022 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,005 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
3,062 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
3,031 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

August Carousel

Fabric Community Update - August 2024

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

View All