March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 |
Solved! Go to Solution.
so it will be right!
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-AB | 12345678 | 12345678 |
ABS-12345678-ABV | 12345678 | 12345678 |
Abd=IUY=BGTYH-AI789_12345678 | 12345678 | 12345678 |
T12345678-12345 | 12345678 | 12345678 |
Abx-ABC23456789-12345678 | 12345678 | 12345678 |
ABA1234HDSC8765 | 12348765 | |
BGS-123-45678 | 12345678 | |
bsg-123-12345678 | 12345678 | 12345678 |
BFH-12345678-123 | 12345678 | 12345678 |
In power quey,click that column and there is option available called split column to extract the numbers from text.
If I answered your question,kindly mark it as solution.
Thanks,
GS
ABC- AB12345-12345678-AB | 12345678 | 12345678 |
ABS-12345678-ABV | ABV | 12345678 |
Abd=IUY=BGTYH-AI789_12345678 | AI789 | |
T12345678-12345 | 12345 | 12345678 |
given column | By splitting | extract 8 digit number |
what I have | what I need |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
97 | |
85 | |
69 | |
61 |
User | Count |
---|---|
138 | |
116 | |
114 | |
99 | |
98 |