I'm attempting to join two tables.
The join validation report indicates several fields with illegal characters. I'm editing a large county file with over 1000 parcels. How to remove characters such as "-" or "/" for a whole column of data without doing it manually?
I prefer the whitelist approach when cleaning up file names, ID columns, etc. Blacklisting chars you don't want like "$%&*@!" etc still would allow things like æ Ñ █ ╬ all of which are valid ascii characters, but probably not charterers you'd want in a primary key or filename.
Of course, we are all missing the line in the title where the OP say '1000 files' ... which pretty much makes our field calculator expression suggestions less than satisfactory. In such cases, it is best to have the person that put them in, in the first place, remove them
If they are simple text files? Python - Way to recursively find and replace string in text files - Stack Overflow