Extract first line of multiple CSV File and save the results

[PSQuery]

Thanks in advance for the help.I have a folder with multiple CSV files. I’d like to be able to extract the first line of each of the files and store the results in a separate CSV file. The newly created CSV file will have the first column as the file name and the second column to be the first line of the file.The output should look something like this (as an exported CSV File):FileName,FirstLineFileName1,Col1,Col2,Col3FileName2,Col1,Col2,Col3Notes:There are other files that should be ignored. I’d like the code to loop through all CSV files which match the name pattern.&

Continue reading...