Remove characters form a string
I am building a field which concatenates a [Work ID] values and [Name of Request] that will be used to name associated files.
Many of the [Name of Request] include characters which are are not allowed in file names (' " / \ # etc.)
How can I replace these characters with an underscore from the string in this formula?
This works for commas..... =[Work ID]@row + " : " + (SUBSTITUTE([Name of Request]@row, ",", "_"))
But, not sure of the syntax to include ' " / \ # ...
This is unpasrable =[Work ID]@row + " : " + (SUBSTITUTE([Name of Request]@row,(",","/",">","." )"_")
Help Article Resources
Check out the Formula Handbook template!