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
¡Resuelto! Ir a solución.
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 '_':