Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm searching for a best-practice method to solve the following problem. I'm trying to extract a 5/6 length digit from the following text string.
I want to extract the 6 length digits from the page column for each unique URL and return the result in the VacancyId column.
There are a lot of different url structures in the Page column.
Is there a best-practice approach for this?
Solved! Go to Solution.
HI @Anonymous
I believe the post got duplicated.
Try my solution in the post below
If these are the only numbers in the string, you can add new custom column as
=Text.Select([Page], {0..9})
Hi Zubair,
Thank you very much, that's very helpfull. 🙂
Unfortunately these are not the only numbers in the string.
The other strings look like this;
Is there a best-practice way to solve this?
HI @Anonymous
I believe the post got duplicated.
Try my solution in the post below
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |