Creating a master file

Simon336697
Simon336697 used Ask the Experts™
on
Hi guys,
I hope you are well and can help.

I have many text files, all with the same  format, that contain, as part of their file names, "summary_sorted.txt".
For example, summary_sorted_a_.txt,  summary_sorted_b.txt, summary_sorted_c.txt etc etc.

The format of each of these files is as follows:

--------------------------------------------------------------------------------------------------- summary_sorted_a.txt
abalone, adversary, aeroplane, at the park;

--------------------------------------------------------------------------------------------------- summary_sorted_b.txt
bat, benign, bipartisan;

I'd like to produce a script that will....

Examine each summary_sorted.txt file.
For each file examined, treat each file examined as 1 line, and copy its entire contents to a new file called master.txt. and
then add a blank line after its pasted contents, before the script goes on to look at the next summary_sorted.txt file.

As an example of what a master.txt file would look like based on the above, would be:

--------------------------------------------------------------------------------------------------- master.txt
abalone, adversary, aeroplane, at the park;

bat, benign, bipartisan;

Any help greatly appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
NVITEnd-user support
Commented:
for /f "tokens=*" %%a in ('dir /b /on summary_sorted_?.txt') do (
  echo %%a>>master.txt
  echo.>>master.txt
)

Open in new window

Author

Commented:
Hi NVIT, thanks for this.

Your solution I thank you for, but its not doing exactly what I want.

With your code, it is creating a master.txt file (which is good), but the contents just contain the file name of each of the files instead of its contents.

Your code does the following..

============================================= master.txt

summary_sorted_a.txt

summary_sorted_b.txt


-------------------------------------------------------------------------------------------------- master.txt

abalone,adversary,aeroplane,at the park;   (this is the contents of summary_sorted_a.txt)

bat, benign, bipartisan; (this is the contents of summary_sorted_b.txt)
IT / Software Engineering Consultant
Top Expert 2016
Commented:
Try this:

@echo off
setlocal EnableDelayedExpansion

for /f "tokens=*" %%a in ('dir /b /on summary_sorted_?.txt') do (
  set /p line=<"%%~a"
  echo.!line!>>master.txt
)

Open in new window

~bp

Author

Commented:
Thanks Bill.
That did it.

Author

Commented:
Thanks to both you guys, you are great.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial