Nov 8, 2010, 10:13 PM
Post #1 of 4
I have several .CSV files with the same number of columns but different number of rows. I want to add a column where the rows are the filenames.
[Edit .CSV file] Add column
In each .CSV, there is 5 columns, and the first row contains the headers. I want to add a 6th column where each row just contains "ex1" for ex1.csv, "ex2" for ex2.csv, and "ex3" for ex3.csv.
A sample line: