Forum Discussion
How to remove text from a column
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
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 👍
3 Replies
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 👍
Hello,
worked perfectly. Thanks a lot!
Have a good day.
