Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 |
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
95 | |
91 | |
37 | |
28 |