Removing spaces, special symbols in header

[mszpot89]

My input txt file has multiple fields:

Processing Location,

Switch In   Out,

Switch In - Out,

Total Sell Amount,

I want to remove all special characters, spaces and get below format:

ProcessingLocation,

SwitchInOut,

SwitchInOut,

TotalSellAmount

Final outcome:

Processing Location,

Switch In & Out,

Switch In & Out,

Total Sell Amount,

[jdunkerley79 · Accepted solution]

You can use a dynamic rename to do the first part:

Note you cannot have fields with the same name so the 'Switch In - Out' ends up SwitchInOut2

For the second part, to rename to final names, would need to understand the logic further. You could use a regular expression to add spaces before capitals or a switch statement to lookup and rename fields as needed.

I have attached a sample doing this.

[mszpot89]

@jdunkerley79 - great thanks! original workflow I developed was much longer!

"Switch In   Out" and "Switch In - Out" were put together only for testing purpose.

After rename I will use simple select tool and that should do the trick.