J
John Nurick
Hi Winterland,
If the layout is exactly the same you can use a Windows command line
("Command Prompt" or "MS DOS window" depending on your version of
WIndows) command to concatenate them.
Arrange things so that your textfiles are the only files in a folder,
open the command prompt window, and use the CD command to navigate to
that folder. Then a command like this
COPY *.txt huge.txt
will combine them all into one.
If this won't import cleanly, you need to make sure
-if the text files contain a header row, open each file and delete the
row. Otherwise you'll end up with 20 copies of the header.
-that each file ends with a line break. Otherwise the first line of one
file will be jammed straight after the last line of the previous one.
If the layout is exactly the same you can use a Windows command line
("Command Prompt" or "MS DOS window" depending on your version of
WIndows) command to concatenate them.
Arrange things so that your textfiles are the only files in a folder,
open the command prompt window, and use the CD command to navigate to
that folder. Then a command like this
COPY *.txt huge.txt
will combine them all into one.
If this won't import cleanly, you need to make sure
-if the text files contain a header row, open each file and delete the
row. Otherwise you'll end up with 20 copies of the header.
-that each file ends with a line break. Otherwise the first line of one
file will be jammed straight after the last line of the previous one.