Dynamic Rename

[jlfromm]

My columns look like this and I want to replace all of the _ with a space  what expression in the Dynamic Rename would I use ?

[DataNath · Accepted solution]

Hey @jlfromm, you'd want to use the following expression:

Replace([_CurrentField_],'_',' ')

Before:

After:

[jlfromm]

Thank you 

[DataNath · Accepted solution]

No problem. Just had a closer look and noticed that some of your fields have duplicate underscores and so the above expression will give you field names like this:

However, if you use this expression, this will prevent duplicate spaces coming in as the replacement:

Regex_Replace([_CurrentField_],'_+',' ')

[PanPP · Accepted solution]

You can always use a select tool after the dynamic replace tool to rename columns.

In the dynamic replace tool, you have multiple options as well (See below)

replacechar([_CurrentField_], " _ ", " ")

REGEX_Replace([_CurrentField_], "\_+", " ")

Regex_Replace([_CurrentField_],'_+',' ')