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, 2017 at 19:17

1 Answer 1

Reset to default
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, 2017 at 19:23
  • How many csv files are you working with? Take a look here: superuser.com/questions/433746/…
    – Scot
    Aug 28, 2017 at 19:27
  • I'll check it out. there are 1,868 files. 230 mb total
    – dropixx
    Aug 28, 2017 at 20:10
  • paste worked the number of files is limited to 256. thanks
    – dropixx
    Aug 28, 2017 at 21:54

You must log in to answer this question.

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