I am generating document but document name may contains special characters like ("\\/;:“|?’><*") but i want to replace this characters with "_".Any quick solution?
Text : "Data/S Load:?"
Expected : "Data_S Load__"
Discussion posts and replies are publicly visible
This replaces all characters in the list in line 4 with the character in line 5.
reduce( substitute(_,_,_), "=)(/&%$§%<>sahggfsah**'#/\||", {"\", "\", "/", ";", ":", """", "|", "?", "’", ">", "<", "*"}, "_" )
In alternative to the good answer of Stefan, an alternative is to use regexreplace on any non word character to _