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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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.