I’ve looked for a solution to this and found some cool ways of doing it using the command line. However, I’d like to use AppleScript so I can incorporate it into other scripts down the road. I need to “merge” all .CSV files in a folder into a single .CSV file. The folder will have approximately 10 files (number varies each day) each with a few hundred records. The headers are the same for each file so I need to keep the first header and remove the header from all others. Ultimately I’d like to have the output file in the same folder and name it with the name of the first file with a slight modification as follows.
Current file names look like this: IC-SchoolName YYYY-YBPoseExport.CSV I’d like to replace the SchoolName with something like “Combined”
I’m new to this and don’t know where to start. Any help would be greatly appreciated.

JBS is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.