Forum Discussion
renee_crozier
Nov 08, 2024Brass Contributor
Trying to Find/Replace Based on Another Sheet in Power Query
I have a list of URLs that have UTF-8 characters in them and I need to replace all of the UTF-8 characters with the actual characters (i.e. %26 to &). I've found two code samples from a separate ...
renee_crozier
Nov 11, 2024Brass Contributor
Apologies. I thought that was what you were asking for. These URLs are created from the asset libraries that live in SharePoint. Does that answer your question?
This is the result after adding your code.
I'm starting to think this isn't possible with the current report I have and I should just keep utilizing the multiple steps I have been in the past.
Lorenzo
Nov 12, 2024Silver Contributor
Hi
Your last picture doesn't help as it shows the [LinkURL] column only. I asked - with the test query - the last 3 columns [LinkURL], [Space?] & [CleanSpace?]
In the meantime feel free to try the suggestion from Mks_1973 (same as the one Sergei Baklan suggested you on your previous thread)