Is there a way to rename a batch of CSV files in a folder based on a value within each? I want to take the first value on the second row and append it to the end of the left-hand side. For example:
HDR,FEC,8.1,FEC Webforms,220.127.116.11, F1N,C00593228,,JOSH LAROSE SENATORIAL VICTORY SUPER PAC
New filename would have a dash and "F1N" added to the end:
New filename: 20160101-2015-12-01-20-45-1034581-F1N.csv
I'm trying to sort through a ton of electronic reports (about 80k files of various sizes), but I need to grab that field to filter out the ones I don't need. Working on a Mac.