
srenin
New User
Nov 8, 2010, 10:13 PM
Post #1 of 4
(4660 views)
|
[Edit .CSV file] Add column
|
Can't Post
|
|
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. Example: ex1.csv ex2.csv ex3.csv 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: Col1,col2,col3,col4,col5 Becomes: Col1,col2,col3,col4,col5,ex1
|