Forum Discussion
Solved
Special Character in Column Name
Hello, I have few columns which have special characters in them. I tried creating a custom column based on column with special character in its name but it did not allow me to do that in Power query...
[#"Work?"] instead of [Work?] will work.
--Nate
[#"Work?"] instead of [Work?] will work.
--Nate
Kudos to Mark from Excel off the grid https://www.youtube.com/watch?v=P3lTPggW2yc
you can create a function to clean up special characters from column names like this
In my case I had a main table with nexted tables that i wanted to clean up before combining so you called my function by
Table.TransformColumns(Source,{"Data", each Table.TransformColumnNames(_,CleanHeaders)})
// Custom function to replace special characters and spaces with an underscore
let
ReplaceSpecialCharacters = (inputText as text) as text =>
let
// Define the characters to replace
specialCharacters = {".", ",", "!", "@", "#", "$", "%", "^", "&", "*", "(", ")", "-", "_", "=", "+", "[", "]", "{", "}", "|", "\", ":", ";", "'", "<", ">", "?", "/"," " },
// Replace each special character with an underscore
replaceUnderscore = List.Accumulate(specialCharacters, inputText, (state, current) => Text.Replace(state, current, "_"))
in
replaceUnderscore
in
ReplaceSpecialCharacters