Forum Discussion
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 ...
That doesn't really answer my question but I understand
Could you run the following testing query (update the file path) and post a picture of the last 3 columns (LinkURL, Space? & CleanSpace?) please
let
Source = Excel.Workbook(File.Contents("\Source Documents\AllContentReport.xlsx"), null, true),
AllContentReport_Sheet = Source{[Item="AllContentReport",Kind="Sheet"]}[Data],
PromotedHeaders = Table.PromoteHeaders(AllContentReport_Sheet, [PromoteAllScalars=true] ),
CheckedSpace = Table.AddColumn(PromotedHeaders, "Space?", each
Text.Contains( [LinkURL], "%20" ), Logical.Type
),
CheckedSpaceAfterClean = Table.AddColumn(CheckedSpace, "CleanSpace?", each
Text.Contains( Text.Clean( [LinkURL] ), "%20" ), Logical.Type
)
in
CheckedSpaceAfterClean
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.