Windows cmd appending file

Question

0.00/5 (No votes)

See more:

I am trying to search a directory with a file extension of .csv. Then once found append the contents to a new .csv file. When I use the pipe I am able to see the .csv file but when I copy the contents to the new file it isn't created with the contents that were originally in the .csv file. Any suggestions?

What I have tried:

This is what I have tried

dir "mydir" | findstr /e .csv > newfile.csv

Posted 1-Nov-18 3:19am

Member 13806552

Updated 1-Nov-18 5:18am

Add a Solution

2 solutions

Solution 1

Use the concatenation output operator ">>":

dir "mydir" | findstr /e .csv >> newfile.csv

Quote:
Yeah I tried that and still got the same result.

Are you sure? Because when I try something very similar it works:

dir . | findstr /e .txt >> newfile.txt

As in:

D:\Temp>cd testdir

D:\Temp\testdir>dir
 Volume in drive D is GriffData
 Volume Serial Number is 4CA5-2F85

 Directory of D:\Temp\testdir

01/11/2018  13:36    <DIR>          .
01/11/2018  13:36    <DIR>          ..
01/11/2018  13:36               652 x.txt
               1 File(s)            652 bytes
               2 Dir(s)  640,177,086,464 bytes free

D:\Temp\testdir>dir . | findstr /e .txt >> newfile.txt

D:\Temp\testdir>type newfile.txt
01/11/2018  13:47                 0 newfile.txt
01/11/2018  13:36               652 x.txt

D:\Temp\testdir>dir . | findstr /e .txt >> newfile.txt

D:\Temp\testdir>type newfile.txt
01/11/2018  13:47                 0 newfile.txt
01/11/2018  13:36               652 x.txt
01/11/2018  13:47                92 newfile.txt
01/11/2018  13:36               652 x.txt

D:\Temp\testdir>

Posted 1-Nov-18 3:38am

OriginalGriff

Updated 1-Nov-18 3:52am

v2

Comments

Member 13806552 1-Nov-18 9:43am

Yeah I tried that and still got the same result.

OriginalGriff 1-Nov-18 9:51am

See updated solution.

Member 13806552 1-Nov-18 10:19am

Thanks for responding I see what you did there the file names are getting appended to the new file I was hoping to append the actual contents so if x.txt says "hello world" then using the command type newfile.txt will also display "hello world" as well I was searching the extension because the file is self generated and I wont know the name but will only want the contents of it.

OriginalGriff 1-Nov-18 10:43am

No, you've have to use "type filename.csv" for each file in order to get the content, and that means you need to start looking at batch files or powershell - or simpler, write some code to do it! :laugh:
It's pretty trivial as a C# app for example.

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)

Richard MacCutchan · Accepted Answer · 2018-11-01T05:19:00

Solution 2

cd "mydir"
FOR %i in (*.csv) DO type %i >> newfile.csv

Posted 1-Nov-18 5:19am

Richard MacCutchan