How to Replace Special Characters("\/;:“|?’

Question

I am generating document but document name may contains special characters like ( "\/;:&ldquo;|?&rsquo;><*") but i want to replace this characters with "_". Any quick solution? 
 
 Text : "Data/S Load:?" 
 Expected : "Data_S Load__"

Stefan Helzle · Accepted Answer

This replaces all characters in the list in line 4 with the character in line 5. reduce( substitute(_,_,_), "=)(/&%$§%<>sahggfsah**'#/\||", {"\", "\", "/", ";", ":", """", "|", "?", "’", ">", "<", "*"}, "_" )

Gabriele Camilli · Answer

In alternative to the good answer of Stefan, an alternative is to use regexreplace on any non word character to _

How to Replace Special Characters("\\/;:“|?’><*") from Document Name(Text) with "_"

Top Replies