Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I would like to ask for your help.
The aim is to remove the word </div> from the URL address.
</div>https://sites.share2.com/sites/Documents/Steuergeraetl.pdf</div>
I can't get over it
Solved! Go to Solution.
Hi,
you could do this simply in Power Query by right clicking the column, select replace values, then just enter </div> in the value to replace and leave the replace with field blank.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hello @BRL7WZ ,
In Power query under the transform tab, you click on extract then Text between two delimiters then you specifiy the delimiters, in your case they're </div>
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
Hello,
worked perfectly. Thanks a lot!
Have a good day.
Hello @BRL7WZ ,
In Power query under the transform tab, you click on extract then Text between two delimiters then you specifiy the delimiters, in your case they're </div>
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
Hi,
you could do this simply in Power Query by right clicking the column, select replace values, then just enter </div> in the value to replace and leave the replace with field blank.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
72 | |
62 | |
52 | |
48 |
User | Count |
---|---|
208 | |
89 | |
61 | |
59 | |
57 |