I am using a simple batch file to merge multiple csv files located in a folder into a single csv file. The batch file contains the command, copy *.csv importfile.csv. The batch file is created by opening Notepad, entering the command, and then saving the file with a .bat extension. The batch file is placed in the folder containing the csv files and run, resulting in a file named importfile.csv.
The csv files I want to merge have a single line with numerous variables. Examples of the original csv files are named long1.csv, long2.csv and long3.csv. The merged file created contains a single line of data with the contents of the three csv files strung together.
If I truncate the amount of data in each csv file (marked short1.csv, etc.), the merged file contains three separate lines of data. This is the desired format of the merged csv file.
Is there a line size limit on the csv file that is causing the different results, or is there something else in the original csv files that is causing the issue?
Thanks for your help.