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: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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
3,470 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,410 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,375 Views
0
Ahmedx
Super User
Super User

‎03-09-2023 12:27 AM

Screen Capture #460.png

Message 6 of 7
3,385 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,411 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,394 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,451 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,420 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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.

View All