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: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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,548 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,488 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,453 Views
0
Ahmedx
Super User
Super User

‎03-09-2023 12:27 AM

Screen Capture #460.png

Message 6 of 7
3,463 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,489 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,472 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,529 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,498 Views
0

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!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All