Dynamic Rename Tool - Replacing all Special Characters with one formula

Question

Hello,

Is there a quick way to replace special characters with underscores or other letters?  For example, we want "$" to be "USD" and any spaces to be "_".  I am currently using REPLACE for each type of special character, each in its own Dynamic Rename Tool back to back to back!

Thanks!

Paul

jasperlch · Accepted Answer

Hi, you could use a Regex_Replace function in the Formula inside the Dynamic Rename tool, where \W inside the square bracket means any non-Word Character. If there are any other characters you would like to be replace by "_", you can put them inside the square bracket. For example [\Wb] will replace any non-word character and  the character 'b' by '_':