Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I have a number of random locations in the below column. What can i use to get the red higlighted text into a new column please? I am thinking is there a way to write to extract only the text between the 5th and 6th '/'? Is there a way to use the Mid function for this please? So in my new Column I would have 'Finance and Procurement',IT and Maint etc..
Column A
/sites/msteams_bgf354-BasilCorporateAwordversions/Shared Documents/Corporate A (word)/Finance and Procurement/UKLP Checked |
/sites/msteams_bgf354-BasilCorporateAwordversions/Shared Documents/Corporate A (word)/IT and Maint/UKLP Checked |
Solved! Go to Solution.
Go to Power Query and Select the column that you need to extract the data. From the home tab, select split column --> By delimiter and enter below information and it will split data into columns with the data in between each / (slashes)
Go to Power Query and Select the column that you need to extract the data. From the home tab, select split column --> By delimiter and enter below information and it will split data into columns with the data in between each / (slashes)
Thanks Nish, thats helped greatly 🙂
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |