blocks|key|1083649|text|more+%2B2+file2.txt+>+temp
type+temp+file1.txt+>+out.txt|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1083650|或者，您可以使用copy。有关详细信息，请参阅copy+/?。|unstyled|offset|length|style|CODE|1083651|copy+/b+temp%2Bfile1.txt++out.txt|1083652|entityMap^0|0|8|4|N|7|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|P|8|@$G|Q|H|R|I|J]|$G|S|H|T|I|J]]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$B|C]]|$1|M|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|N|$]]

blocks|key|1083695|text|使用FOR命令逐行回显文件，并使用“跳过”选项忽略一些起始行...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1083696|FOR+/F+"skip=1"+%25i+in+(file2.txt)+do+@echo+%25i|code-block|syntax|javascript|1083697|您可以重定向批处理文件的输出，其中包含以下内容：|1083698|FOR+/F+%25%25i+in+(file1.txt)+do+@echo+%25%25i
FOR+/F+"skip=1"+%25%25i+in+(file2.txt)+do+@echo+%25%25i|1083699|请注意，当在批处理文件中使用FOR变量时，会出现两个%25。|1083700|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Use the FOR command to echo a file line by line, and with the 'skip' option to miss a number of starting lines...

<pre><code>FOR /F "skip=1" %i in (file2.txt) do @echo %i
</code></pre>

You could redirect the output of a batch file, containing something like...

<pre><code>FOR /F %%i in (file1.txt) do @echo %%i
FOR /F "skip=1" %%i in (file2.txt) do @echo %%i
</code></pre>

Note the double % when a FOR variable is used within a batch file.

blocks|key|1083767|text|我知道你说你不能安装任何软件，但我不确定这个限制有多严格。无论如何，我也遇到了同样的问题(试图连接两个头文件可能相同的文件)，我想我应该为其他访问此页面的人提供另一种解决方案，因为它对我来说非常有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1083768|在windows中尝试了一大堆命令后，我感到非常沮丧，也尝试了各种图形化编辑器，这些编辑器承诺可以打开大文件，但后来却无法打开，最终我回到了Linux的根目录，打开了Cygwin提示符。两个命令：|1083769|cp+file1.csv+out.csv
tail+-n%2B2+file2.csv+>>+out.csv|code-block|syntax|javascript|1083770|对于file1.csv+800MB和file2.csv+400MB，这两个命令在我的机器上耗时不到5秒。在Cygwin提示符中，同样如此。我认为在Cygwin中Linux命令应该很慢，但这种方法比我能找到的任何windows方法都要容易得多。|offset|length|style|CODE|1083771|entityMap^0|0|0|0|2|9|I|9|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@$K|U|L|V|M|N]|$K|W|L|X|M|N]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

I know you said that you couldn't install any software, but I'm not sure how tight that restriction is. Anyway, I had the same issue (trying to concatenate two files with presumably the same headers) and I thought I'd provide an alternative answer for others who arrive at this page, since it worked just great for me.

After trying a whole bunch of commands in windows and being severely frustrated, and also trying all sorts of graphical editors that promised to be able to open large files, but then couldn't, I finally got back to my Linux roots and opened my Cygwin prompt. Two commands:

<pre><code>cp file1.csv out.csv
tail -n+2 file2.csv &gt;&gt; out.csv
</code></pre>

For <code>file1.csv</code> 800MB and <code>file2.csv</code> 400MB, those two commands took under 5 seconds on my machine. In a Cygwin prompt, no less. I thought Linux commands were supposed to be slow in Cygwin but that approach took far less effort and was way easier than any windows approach I could find.

blocks|key|1298933|text|我使用这个，它对我来说效果很好：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1298934|TYPE+\\Server\Share\Folder\*.csv+>>+C:\Folder\ConcatenatedFile.csv|offset|length|style|CODE|1298935|当然，在每次运行之前，您必须执行DELETE+C:\Folder\ConcatenatedFile.csv|1298936|唯一的问题是，如果所有文件都有头文件，那么它将在所有文件中重复。|1298937|entityMap^0|0|0|1U|0|G|11|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

I use this, and it works well for me:

<code>TYPE \\Server\Share\Folder\*.csv &gt;&gt; C:\Folder\ConcatenatedFile.csv</code>

Of course, before every run, you have to <code>DELETE C:\Folder\ConcatenatedFile.csv</code>

The only issue is that if all files have headers, then it will be repeated in all files.

blocks|key|1083886|text|我没有足够的名誉点来评论使用*.csv+>>+ConcatenatedFile.csv的建议，但我可以添加一个警告：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1083887|如果您在用于连接的同一目录中创建ConcatenatedFile.csv文件，则该文件将被添加到自身。|1083888|entityMap^0|E|T|0|G|K|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

I don't have enough reputation points to comment on the recommendation to use <code>*.csv &gt;&gt; ConcatenatedFile.csv</code>, but I can add a warning:

If you create <code>ConcatenatedFile.csv</code> file in the same directory that you are using for concatenation it will be added to itself.

blocks|key|1299040|text|我会把这个放在ghostdog74的评论中，除非我的代表太低了，所以就这样吧。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1299041|more+%2B2+file2.txt+>+temp|offset|length|style|CODE|1299042|这段代码实际上会忽略文件的第1行和第2行。OP希望保留第一个文件中的所有行(以保留标题行)，然后排除第二个文件中的第一行(假设是相同的标题行)，因此要仅排除标题行，OP应使用more+%2B1。|1299043|type+temp+file1.txt+>+out.txt|1299044|目前还不清楚这段代码的结果是什么。是将temp附加到file1.txt+(根据需要)，还是将file1.txt附加到temp+(不需要，因为标题行将隐藏在结果文件的中间)。|1299045|此外，对于大文件(例如300MB)，这些操作需要很长时间|1299046|entityMap^0|0|0|O|0|2F|7|0|0|T|0|J|4|Q|9|1A|9|1M|4|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@$D|W|E|X|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@$D|Z|E|10|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|11|8|@$D|12|E|13|F|G]|$D|14|E|15|F|G]|$D|16|E|17|F|G]|$D|18|E|19|F|G]]|9|@]|A|$]]|$1|N|3|O|5|6|7|1A|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|Q|$]]

I would put this in a comment to ghostdog74, except my rep is too low, so here goes.
 
<code>more +2 file2.txt &gt; temp</code>
 
This code will actually ignore rows 1 and 2 of the file. OP wants to keep all rows from the first file (to maintain the header row), and then exclude the first row (presumably the same header row) on the second file, so to exclude only the header row OP should use <code>more +1</code>.

<code>type temp file1.txt &gt; out.txt</code>
 
It is unclear what order results from this code. Is <code>temp</code> appended to <code>file1.txt</code> (as desired), or is <code>file1.txt</code> appended to <code>temp</code> (undesired as the header row would be buried in the middle of the resulting file).
 
In addition, these operations take a REALLY LONG TIME with large files (e.g. 300MB)

blocks|key|1083973|text|more+%2B2+file1.txt+>+type+>+out.txt+&&+type+file2.txt+>+out.txt|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1083974|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

blocks|key|1083988|text|下面是如何做到这一点：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1083989|(type+file1.txt+&&+more+%2B1+file2.txt)+>+out.txt|code-block|syntax|javascript|1083990|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here's how to do this:

<pre><code>(type file1.txt &amp;&amp; more +1 file2.txt) &gt; out.txt
</code></pre>

blocks|key|1083995|text|在powershell中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1083996|Get-Content+file1.txt+%7C+Out-File+out.txt
Get-Content+file2.txt+%7C+Select-Object+-Skip+1+%7C+Out-File+-Append+out.txt|code-block|syntax|javascript|1083997|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In powershell:

<pre><code>Get-Content file1.txt | Out-File out.txt
Get-Content file2.txt | Select-Object -Skip 1 | Out-File -Append out.txt
</code></pre>

blocks|key|1084108|text|这将获取带有标题的Test.txt，并附加Test1.txt和Test2.txt，并在分别从第二个和第三个文件中剥离标题后将结果写入Testresult.txt文件：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1084109|type+C:\Test.txt+>+C:\Testresult.txt+&&+more+%2B1+C:\Test1.txt+>>+C:\Testresult.txt+&&+more+%2B1+C:\Test2.txt+>>+C:\Testresult.txt|code-block|syntax|javascript|1084110|entityMap^0|9|8|L|9|V|9|1U|E|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|L|$]]

This takes <code>Test.txt</code> with headers and appends <code>Test1.txt</code> and <code>Test2.txt</code> and writes results to <code>Testresult.txt</code> file after stripping headers from second and third files respectively:

<pre><code>type C:\Test.txt &gt; C:\Testresult.txt &amp;&amp; more +1 C:\Test1.txt &gt;&gt; C:\Testresult.txt &amp;&amp; more +1 C:\Test2.txt &gt;&gt; C:\Testresult.txt
</code></pre>

blocks|key|1299233|text|您也可以简单地尝试以下操作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1299234|type+file2.txt+>>+file1.txt|code-block|syntax|javascript|1299235|它会将file2.txt的内容追加到file1.txt的末尾|1299236|如果您需要原始file1.txt，请提前备份。或者你可以这样做|1299237|type+file1.txt+>+out.txt
type+file2.txt+>>+out.txt|1299238|如果要在第一个文件的末尾换行，可以在追加之前尝试执行以下命令。|1299239|type+file1.txt+>+out.txt
printf+"\n"+>>+out.txt
type+file2.txt+>>+out.txt|1299240|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

You can also simply try this

<pre><code>type file2.txt &gt;&gt; file1.txt
</code></pre>

It will append the content of file2.txt at the end of file1.txt

If you need original file1.txt, take a backup beforehand. Or you can do this

<pre><code>type file1.txt &gt; out.txt
type file2.txt &gt;&gt; out.txt
</code></pre>

If you want to have a line break at the end of the first file, you can try the following command before appending.

<pre><code>type file1.txt &gt; out.txt
printf "\n" &gt;&gt; out.txt
type file2.txt &gt;&gt; out.txt
</code></pre>

blocks|key|1299304|text|copy的帮助说明可以使用通配符将多个文件连接成一个文件。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1299305|例如，要将当前文件夹中以"abc“开头的所有.txt文件复制到名为xyz.txt的单个文件中：|1299306|copy+abc*.txt+xyz.txt|code-block|syntax|javascript|1299307|entityMap^0|0|4|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

The help for <code>copy</code> explains that wildcards can be used to concatenate multiple files into one.

For example, to copy all .txt files in the current folder that start with "abc" into a single file named xyz.txt:

<pre><code>copy abc*.txt xyz.txt
</code></pre>

I need to concatenate some relatively large text files, and would prefer to do this via the command line. Unfortunately I only have Windows, and cannot install new software.

<pre><code>type file1.txt file2.txt &gt; out.txt
</code></pre>

allows me to almost get what I want, but I don't want the 1st line of file2.txt to be included in out.txt.

I have noticed that <code>more</code> has the <code>+n</code> option to specify a starting line, but I haven't managed to combine these to get the result I want. I'm aware that this may not be possible in Windows, and I can always edit out.txt by hand to get rid of the line, but is there a simple way of doing it from the command line?

Concatenate text files with Windows command line, dropping leading lines

Windows

Linux

我需要连接一些相对较大的文本文件，并且更喜欢通过命令行来完成。不幸的是，我只有Windows，不能安装新软件。type file1.txt file2.txt > out.txt允许我几乎得到我想要的东西，但我不希望file2.txt的第一行包含在out.txt中。我注意到more有+n选项来指定起始行，但是我没有设法...

问使用Windows命令行连接文本文件，删除前导行
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Windows命令行连接文本文件，删除前导行EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Windows命令行连接文本文件，删除前导行
EN