M Code to strip almost all non-alphanumeric characters from a column

[JGordon11]

In PQ in a column named Thru, I'd like to delete all non-alphanumeric characters with the exception of + and -. Anyone know M code step(s) to accomplish this following a step called #"Promoted Headers"?

 

[arunsjain]

Hi

Try following link

Bulk Find And Replace In Power Query | How To Excel

www.howtoexcel.org

Cheers!!

 

[Norie]

You could use code like this in a new column.

= Table.AddColumn(#"Changed Type", "New Thru", each Text.Combine(List.RemoveItems(Text.ToList([Thru]), {"0","1","2","3","4","5","6","7","8","9"}))
)

Obviously you would need to add all the characters you want to replace, though it might be possible to get that from another table.

You can indeed get the characters to remove from another table, the following code assumes you have a table named 'Replace' with a column named 'Characters' which lists all the characters you want to replace.

= Table.AddColumn(#"Renamed Columns", "NewThru", each Text.Combine(List.RemoveItems(Text.ToList([Thru]), Table.Column(Replace, "Characters"))))