Power Query: Remove Special Characters from Text

Function: This function, RemoveSpecialChars, cleans a text string by removing special characters, retaining only letters and numbers.

Add fx to the blank query (Advanced Editor)

Usage Example: 

Using = RemoveSpecialChars("H3ll0! W@rld#") will return "H3ll0 Wrld". The function operates by removing specified special characters from the input text, ensuring a clean output.

Power Query code for use and reuse:

RemoveSpecialChars = (inputText as text) as text =>

    let

        CleanedText = Text.Remove(inputText, {"!", "@", "#", "$", "%", "^", "&", "*", "(", ")", "-", "_", "=", "+", "[", "]", "{", "}", ";", ":", "'", ",", ".", "<", ">", "/", "?", "|", "\"})

    in

        CleanedText

in

    RemoveSpecialChars

Invoke function on desired column

This is the M-code that Power Query usually makes on every step that we do:

= Table.AddColumn(#"Added Conditional Column", "Query1", each Query1([Customer]))

Need code and instructions? Free of charge =)

pq_RemoveSpecialCharacters.txt

Download TXT • 1KB