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: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

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,478 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,418 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,383 Views
0
Ahmedx
Super User
Super User

‎03-09-2023 12:27 AM

Screen Capture #460.png

Message 6 of 7
3,393 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,419 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,402 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,459 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,428 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.

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