Power Query, HTML Sonderzeichen ersetzen
neue Abfrage erstellen, Name fxReplaceHTMLEntities --- SCHNIPP --- (inputText as text) as text => let // Liste der zu ersetzenden HTML-Sonderzeichen und deren Entsprechungen HtmlEntities = [ #"%20" = " ", #"%21" = "!", #"%22" = """", #"%23" = "#", #"%24" = "$", #"%25" = "%", #"%26" = "&", #"%27" = "'", #"%28" = "(", #"%29" = ")", #"%2A" = "*", #"%2B" = "+", #"%2C" ...