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,
Résolu ! Accéder à la 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.
@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.