by nwcooper2004 » Tue Mar 15, 2016 6:53 pm
I have thousands of files in the following format where the first two letters of filename are abbreviations of a State, the next letters are the County and the numbers are the date. Basically I want to replace the State abbreviation with County, leave the rest of the characters the same and if possible put the date in a different format in front of the filename. so for example the following filenames would change from:
AK-Greely_Subdivision-20160325.csv
CA-Alameda-20160318.csv
TX-Anderson-20160405.csv
FL-Miami-dade-20160310.csv
to:
03_25_2016-County-Greely_Subdivision.csv
03_18_2016-County-Alameda.csv
04_05_2016-County-Anderson.csv
04_05_2016-County-Miami-dade.csv
Thanks in advance. I will definitely make a donation for the help!
Neil