2

in other words I am trying to join a few hundred csv files that are 1 column each and I would like each csv file to create a new column instead of creating a new row.

This is the command I'm currently using:

gls-Mac-Pro:~ gliiiitch$ cat *.csv >merged_files.csv

Improve this question
1
  • Do you mean you want to add colums of data? Do you have a sample of what you have and a template of what you want the result to be? – Allan Aug 28 '17 at 19:17
2

Try the paste command:

paste *.csv > merged_files.csv

You may have to experiment to be sure that the column order matches your expectations...

Improve this answer
4
  • thanks for the reply, terminal returned the error "too many open files" – dropixx Aug 28 '17 at 19:23
  • How many csv files are you working with? Take a look here: superuser.com/questions/433746/… – Scot Aug 28 '17 at 19:27
  • I'll check it out. there are 1,868 files. 230 mb total – dropixx Aug 28 '17 at 20:10
  • paste worked the number of files is limited to 256. thanks – dropixx Aug 28 '17 at 21:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .