Skip to main content
Unix & Linux

Return to Question

Title, formatting (code), +tag: text-processing
Source Link
Jeff Schaller ♦
Jeff Schaller ♦
  • 68.8k
  • 35
  • 122
  • 264

I have csvCSV files which are in a form of:

1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9

.....

up to 18.csv.

I want the result in result.csv to be:

1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9

I tried cat but it appends one another after only. Any help is appreciated. I also want to transpose the csvCSV such that 1.csv is converted to:

1
2
3
4
5
6
7
8

Any help is appreciated?

I have csv files which are in a form of

1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9

.....

up to 18.csv.

I want the result in result.csv to be

1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9

I tried cat but it appends one another after only. Any help is appreciated. I also want to transpose the csv such that 1.csv is converted to:

1
2
3
4
5
6
7
8

Any help is appreciated?

I have CSV files which are in a form of:

1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9

.....

up to 18.csv.

I want the result in result.csv to be:

1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9

I tried cat but it appends one another after only. I also want to transpose the CSV such that 1.csv is converted to:

1
2
3
4
5
6
7
8
Title, formatting (code), +tag: text-processing
Source Link
edit approved Jan 18, 2017 at 13:03
John N
edit approved Jan 18, 2017 at 13:03
John N
  • 2.1k
  • 1
  • 16
  • 17

how How to combine csv 'sCSV files

I have CSVcsv files which are in a form of

1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9

.....

upto 18.csvup to 18.csv.

I want the result in fileresult.csv to be

result.csv
1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9

I tried catcat but it appends one another after only.Any Any help is appreciated.I I also want to transpose the CSV in the sense My 1.csvcsv such that 1.csv is converted to be like:

1
2
3
4
5
6
7
8

Any help is appreciated?

how to combine csv 's

I have CSV files which are in a form of

1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9

.....

upto 18.csv.

I want the result in file to be

result.csv
1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9

I tried cat but it appends one another after only.Any help is appreciated.I also want to transpose the CSV in the sense My 1.csv to be like

1
2
3
4
5
6
7
8

Any help is appreciated?

How to combine CSV files

I have csv files which are in a form of

1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9

.....

up to 18.csv.

I want the result in result.csv to be

1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9

I tried cat but it appends one another after only. Any help is appreciated. I also want to transpose the csv such that 1.csv is converted to:

1
2
3
4
5
6
7
8

Any help is appreciated?

added 154 characters in body
Source Link
RKR
RKR
  • 377
  • 4
  • 12

I have CSV files which are in a form of

1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9

.....

upto 18.csv.

I want the result in file to be

result.csv
1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9

I tried cat but it appends one another after only.Any help is appreciated.I also want to transpose the CSV in the sense My 1.csv to be like

1
2
3
4
5
6
7
8

Any help is appreciated?

I have CSV files which are in a form of

1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9

.....

upto 18.csv.

I want the result in file to be

result.csv
1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9

I tried cat but it appends one another after only.Any help is appreciated.

I have CSV files which are in a form of

1.csv
1,2,3,4,5,6,7,8
2.csv
2,4,5,7,8,8,9,5
3.csv
2,3,4,5,6,7,8,9

.....

upto 18.csv.

I want the result in file to be

result.csv
1,2,3,4,5,6,7,8,2,4,5,7,8,8,9,5,2,3,4,5,6,7,8,9

I tried cat but it appends one another after only.Any help is appreciated.I also want to transpose the CSV in the sense My 1.csv to be like

1
2
3
4
5
6
7
8

Any help is appreciated?

Source Link
RKR
RKR
  • 377
  • 4
  • 12