blocks|key|1834290|text|将冒号替换为管道，执行cut命令，然后再次将第一个管道替换为冒号：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1834291|sed+'s/:/%7C/'+input.txt+%7C+cut+...+%7C+sed+'s/%7C/:/'|code-block|syntax|javascript|1834292|您可能需要调整cut命令的列数，以确保不计算标题。|1834293|entityMap^0|B|3|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|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

Replace the colon with a pipe, do your <code>cut</code> command, then replace the first pipe with a colon again:

<pre><code>sed 's/:/|/' input.txt | cut ... | sed 's/|/:/'
</code></pre>

You may need to adjust the column number for the cut command, to ensure you don't count the header.

blocks|key|1563259|text|将“：”改为“%7C”，这样标题就是另一个字段，而不是第一个字段的一部分。您可以在最初生成数据的任何方式中执行此操作，也可以在cut之前通过tr+':'+'%7C'传递数据。您的其余字段将被%2B1偏移，但这应该很容易补偿。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1563260|entityMap^0|1P|3|1W|A|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Turn the ':' into '|', so that the header is another field, rather than part of the first field. You can do that either in whatever generates the data to begin with, or by passing the data through <code>tr ':' '|'</code> before <code>cut</code>. The rest of your fields will be offset by +1 then, but that should be easy enough to compensate for.

blocks|key|3200040|text|你的问题是HeaderX后面跟着'‘，这不是你在cut中使用的'%7C’分隔符。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3200041|您可以使用:将行分成两部分，类似于"cut+delimiter+1+--delimiter=：YOURFILE"，然后删除第一列，然后放回标题。|3200042|entityMap^0|W|1|0|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|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

Your problem is that HeaderX are followed by ':' which is not the '|' delimiter you use in cut.

You could separate first your lines in two parts with :, with something like
"cut -f 1 --delimiter=: YOURFILE", then remove the first column and then put back the headers.

blocks|key|3200173|text|awk可以处理多个分隔符。所以另一个选择是..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3200174|jkern@ubuntu:~/scratch$+cat+./data188+
Header1:value1%7Cvalue2%7Cvalue3%7C
Header2:value4%7Cvalue5%7Cvalue6%7C
jkern@ubuntu:~/scratch$+awk+-F"[:%7C]"+'{+print+$1+$3+$4+}'+./data188+
Header1value2value3
Header2value5value6|code-block|syntax|javascript|3200175|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|$]]

awk can handle multiple delimiters. So another alternative is... 

<pre><code>jkern@ubuntu:~/scratch$ cat ./data188 
Header1:value1|value2|value3|
Header2:value4|value5|value6|
jkern@ubuntu:~/scratch$ awk -F"[:|]" '{ print $1 $3 $4 }' ./data188 
Header1value2value3
Header2value5value6
</code></pre>

blocks|key|3200076|text|不需要cut，只需使用sed即可完成|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3200077|sed+'s/:[%5E%7C]*%7C/:/'+input.txt|code-block|syntax|javascript|3200078|entityMap^0|3|3|B|3|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

you can do it just with <code>sed</code> without <code>cut</code>:

<pre><code>sed 's/:[^|]*|/:/' input.txt
</code></pre>

blocks|key|1563402|text|我的解决方案是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1563403|$+sed+'s,:,%7C,'+data+%7C+awk+-F'%7C'+'BEGIN{OFS="%7C"}{$2="";+print}'+%7C+sed+'s,%7C%7C,:,'
Header1:value2%7Cvalue3%7C
Header2:value5%7Cvalue6%7C|code-block|syntax|javascript|1563404|用%7C|offset|length|style|CODE|1563405|-F'%7C'替换:告诉awk使用%7C符号作为字段分隔符|unordered-list-item|1563406|
|1563407|在每行中我们用空字符串替换第二个(因为标题现在变成第一个)字段，并用新的字段分隔符|1563408|打印结果行返回标题用:|1563409|替换第一个%7C|1563410|1563411|不是完美的，但应该是有效的。|1563412|entityMap^0|0|0|1|1|0|0|5|7|1|A|3|F|1|0|0|0|A|1|0|5|1|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@$I|15|J|16|K|L]]|9|@]|A|$]]|$1|M|3|N|5|O|7|17|8|@$I|18|J|19|K|L]|$I|1A|J|1B|K|L]|$I|1C|J|1D|K|L]|$I|1E|J|1F|K|L]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1G|8|@]|9|@]|A|$]]|$1|R|3|S|5|O|7|1H|8|@]|9|@]|A|$]]|$1|T|3|U|5|O|7|1I|8|@$I|1J|J|1K|K|L]]|9|@]|A|$]]|$1|V|3|W|5|6|7|1L|8|@$I|1M|J|1N|K|L]]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1P|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|11|$]]

My solution:

<pre><code>$ sed 's,:,|,' data | awk -F'|' 'BEGIN{OFS="|"}{$2=""; print}' | sed 's,||,:,'
Header1:value2|value3|
Header2:value5|value6|
</code></pre>

<ul>
<li>replace <code>:</code> with <code>|</code></li>
<li><code>-F'|'</code> tells <code>awk</code> to use <code>|</code> symbol as field separator</li>
<li>in each line we replace 2nd (because header now becomes first) field with empty string and printing result line with new field separator (<code>|</code>)</li>
<li>return back header by replacing first <code>|</code> with <code>:</code></li>
</ul>

Not perfect, but should works.

blocks|key|3288634|text|$+cat+file.txt+%7C+grep+'Header1'+%7C+awk+-F"1"+'{+print+$1+$2+$3+$4}'|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3288635|这将在单独的列中打印所有值。您可以打印任意数量的列。|3288636|entityMap^0|0|1U|0|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|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

<code>$ cat file.txt | grep 'Header1' | awk -F"1" '{ print $1 $2 $3 $4}'</code>

This will print all values in separate columns. You can print any number of columns.

blocks|key|3288651|text|只是插入了一个Perl解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3288652|(根据需要重新排列/删除字段)|3288653|-l有效地在每个打印语句中添加了一个换行符|3288654|-a自动拆分模式使用-F表达式将每一行拆分为数组@F|3288655|-n在-e代码周围添加了一个循环|3288656|-e您的'one+liner‘遵循此选项|3288657|$+perl+-F[:\%7C]+-lane+'print+"$F[0]:$F[1]%7C$F[2]%7C$F[3]"'+input.txt|code-block|syntax|javascript|3288658|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|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|W|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|X|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|Y|8|@]|9|@]|A|$O|P]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Just chiming in with a Perl solution: 
(rearrange/remove fields as needed) 
 
-l effectively adds a newline to every print statement 
-a autosplit mode splits each line using the -F expression into array @F 
-n adds a loop around the -e code 
-e your 'one liner' follows this option

<pre><code>$ perl -F[:\|] -lane 'print "$F[0]:$F[1]|$F[2]|$F[3]"' input.txt
</code></pre>

I have a file like the following:
<pre><code>Header1:value1|value2|value3|
Header2:value4|value5|value6|
</code></pre>
The column number is unknown and I have a function which can return the column number.
And I want to write a script which can remove one column from the file. For exampple, after removing column 1, I will get:
<pre><code>Header1:value2|value3|
Header2:value5|value6|
</code></pre>
I use <code>cut</code> to achieve this and so far I can give the values after removing one column but without the headers. For example
<pre><code>value2|value3|
value5|value6|
</code></pre>
Could anyone tell me how can I add headers back? Or any command can do that directly? Thanks.

UNIX Shell Script remove one column from the file

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

问UNIX Shell脚本从文件中删除一列
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问UNIX Shell脚本从文件中删除一列EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问UNIX Shell脚本从文件中删除一列
EN