Removing special characters from field name

Hi everyone,

I have this issue where I have to import a .csv file with a lot of quotation marks in it. All the field names have quotation around the actual names. I have no problems in getting rid of these when it comes to the field values. But when I want to remove the quotations from the field names themselves I have no luck.

I know I could use the Selection tool and then manually rename all the field names. However I have a lot of different field and would like to do this in a more effective manner.

For the fields themselves I used the Multi-Field Formula and typed "REGEX_Replace([_CurrentField_], '"', '')"

I tried doing the same for the field names: "REGEX_Replace([_CurrentFieldName_], '"', '')"

It had no effect.

Does anyone know how to guide me forward in this?

(Attached is a screenshot of some field names)

//Johannes

Skärmavbild 2020-02-28 kl. 15.44.49.png

Accepted answers

estherb47

Hi @johannescruz

Have you tried a simple "Replace" function in the Dynamic Rename tool? in this instance, where you are replacing quote marks, you don't need to use Regex_Replace, which is for pattern recognition. You could also try the ReplaceChar function.