How do I merge two csv files to one csv file.

Question

1.00/5 (3 votes)

See more:

I have two csv files in different folders and would like to merge them. I am using copy command in windows cmd but the first line from second file is getting appended to the last line of first file.
How do I start copying from new line.
COPY t1.csv + t2.csv result.csv

result.csv file is

hey this is t1hey this is t2

I want
hey this is t1
hey this is t2

What I have tried:

I have tried using /r/n but no use.

Posted 8-Jun-16 8:20am

Member 12573208

Updated 9-Jun-16 3:59am

Add a Solution

Comments

ZurdoDev 8-Jun-16 14:56pm

How did you try to use r/n?

Member 12573208 8-Jun-16 15:07pm

COPY t1.csv +/r/n + t2.csv result.csv

Sergey Alexandrovich Kryukov 8-Jun-16 15:12pm

Using copy and/or cmd.exe is not a programming question. Sorry, this is off-topic.
If this is just two file, what preventing you from manually adding an empty line in the first file at the end?

If you want to use many files in the batch, there are many solutions around, like
http://stackoverflow.com/questions/18375716/how-to-concatenate-files-with-a-new-line-between-files-in-dos-command-line...

—SA

Sergey Alexandrovich Kryukov 8-Jun-16 15:14pm

Here is one user-level soluton for you. Create a file with empty line; say, it's name is 1-line.txt.
Use copy t1.csv + 1-line.txt + t2.sdv + 1-line.txt + t2.txt
And so on...

I did not post formal answers only because this is off-topic and low-tech...

—SA

Member 12573208 8-Jun-16 15:40pm

I am looking for a command line keyword not a work around. but thanks anyways.

Richard MacCutchan 9-Jun-16 4:07am

There is no command line keyword, you need to take Sergey's advice and your problem will be resolved. Alternatively, you could do it the easy way and use copy and paste in an editor like Notepad.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2016-06-09T03:59:00

Despite the fact this is off-topic, I'm going to give this a formal solution just to get it out of the list of Unanswered Questions.

If you insist on doing this in a cmd window then you have 2 options.

1. Follow the advice given by Sergey... Either have a buffer file to include in the COPY command or use the technique provided on the link.

2. Use TYPE instead of COPY (which is actually used on the link in SA's comment)

TYPE t1.csv > t3.csv
ECHO. >> t3.csv
TYPE t2.csv >> t3.csv

Alternatives have already been mentioned by Richard - use Copy+Paste in something like Notepad, or use Excel to load the data.
If this is going to happen often then write a program to merge the text from the files.

How do I merge two csv files to one csv file.

1 solution

Solution 1

Add your solution here

Preview 0

How do I merge two csv files to one csv file.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us