Removing spaces, special symbols in header

Question

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,

TotalSellAmount

Final outcome:

Processing Location,

Switch In & Out,

Total Sell Amount,

jdunkerley79 · Accepted Answer

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.