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

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__"

gabriele.camilli · Accepted Answer

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

stefanhelzle0001 · Answer

This replaces all characters in the list in line 4 with the character in line 5.

reduce(
  substitute(_,_,_),
  "=)(/&%$Â§%<>sahggfsah**'#/\||",
  {"\", "\", "/", ";", ":", """", "|", "?", "â`™", ">", "<", "*"},
  "_"
)

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

2 replies

Sign up

Login with SSO

Login to the community

Login with SSO