blocks|key|1359681|text|这可能适用于您(GNU+sed)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1359682|sed+-r+':a;s/%5E([%5E"]*("[%5E"%7C]*"[%5E"]*)*"[%5E"%7C]*)\%7C/\1/g;ta'+file|code-block|syntax|javascript|1359683|这将删除双引号中的%7C，但它不支持带引号的引号，因此要小心！|offset|length|style|CODE|1359684|entityMap^0|0|0|9|1|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|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

This might work for you (GNU sed):

<pre><code>sed -r ':a;s/^([^"]*("[^"|]*"[^"]*)*"[^"|]*)\|/\1/g;ta' file
</code></pre>

This removes <code>|</code> within double quotes however it does not cater for quoted quotes, so beware!

blocks|key|1359657|text|有些事情你不会使用SED，我会说这就是其中之一。尝试将python脚本与re库一起使用，或者仅使用普通的字符串操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1359658|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

There are somethings you don't use SED for, I'd say this is one of those things. Try using a python script with the re library or just plain string manipulation.

blocks|key|5298557|text|我认为这段C%2B%2B代码可以满足您的需求。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5298558|//+$+g%2B%2B+-Wall+-Wextra+-std=c%2B%2B11+main.cpp

#include+<iostream>

int+main(int,+char*[])+{
++bool+str+=+false;
++char+c;
++std::ios_base::sync_with_stdio(false);
++std::cin.tie(nullptr);
++while+(std::cin.get(c))+{
++++if+(c+==+'%7C')+{
++++++if+(str)+{
++++++++std::cout+<<+'\\';+}+}
++++else+if+(c+==+'"')+{
++++++//+Toggle+string+parsing.
++++++str+=+!str;+}
++++else+if+(c+==+'\\')+{
++++++//+Skip+escaped+chars.
++++++std::cout+<<+c;
++++++std::cin.get(c);+}
++++std::cout+<<+c;+}
++return+0;+}|code-block|syntax|javascript|5298559|本例中sed的问题在于，为了跟踪您所处的状态(字符串或非字符串)，您需要了解更多的基础知识。|5298560|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I think this C++ code does what you need.

<pre><code>// $ g++ -Wall -Wextra -std=c++11 main.cpp

#include &lt;iostream&gt;

int main(int, char*[]) {
 bool str = false;
 char c;
 std::ios_base::sync_with_stdio(false);
 std::cin.tie(nullptr);
 while (std::cin.get(c)) {
 if (c == '|') {
 if (str) {
 std::cout &lt;&lt; '\\'; } }
 else if (c == '"') {
 // Toggle string parsing.
 str = !str; }
 else if (c == '\\') {
 // Skip escaped chars.
 std::cout &lt;&lt; c;
 std::cin.get(c); }
 std::cout &lt;&lt; c; }
 return 0; }
</code></pre>

The problem with sed in this example is you need to know more than the basics in order to track which state you are in (string or not).

blocks|key|5298581|text|下面是一个脚本，用于将具有管道分隔值的文件转换为遵循TSV文件的更简单约定的文件。它假设有可用的PHP解释器。如果脚本被另存为psv2tsv，并且可以在Mac或Linux环境中执行，那么psv2tsv+-h应该提供更多细节。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5298582|示例用法(在输出中使用<TAB>表示制表符)：|5298583|$+psv2tsv+<<<+$'73779087%7C"UCGr4c0_zShyHbctxJJrJ03w"%7C"ItsMattSpeaking+%7C+SuPra"'
+73779087<TAB>UCGr4c0_zShyHbctxJJrJ03w<TAB>ItsMattSpeaking+%7C+SuPra<TAB>

$+psv2tsv+<<<+$'a%7C"b%7Cc\t\d"%7C"e\n"'
a<TAB>b%7Cc\t\d<TAB>e\n<TAB>|code-block|syntax|javascript|5298584|脚本：|5298585|#!/usr/bin/env+php

<?php
#+Author:+pkoppstein+at+gmail.com+12/2015
#+Use+at+your+own+risk.
#+Input+-+pipe-separated+values+along+the+lines+of+CSV.
#+Translate+embedded+newline+and+tab+characters.

function+help()+{
++global+$argv;
++echo+<<<EOT
Syntax:+{$argv[0]}+[filepath]

Convert+a+file+or+stream+of+records+with+pipe-separated+values+to+the
TSV+(tab-separated+value)+format.++If+no+argument+is+specified,+or+if
filepath+is+specified+as+-,+then+input+is+taken+from+stdin.

The+input+is+assumed+to+be+like+a+CSV+file+but+with+pipe+characters
(%7C)+used+instead+of+commas.++The+output+follows+the+simpler
conventions+of+TSV+files.

Note+that+each+tab+in+the+input+is+translated+to+"\\t",+and+each
embedded+newline+is+translated+to+"\\n".++Each+translated+record+is
then+written+to+stdout.++See+PHP's+fgetcsv+for+further+details.

EOT;
}

$file+=+($argc+>+1+)+?+$argv[1]+:+'php://stdin';

if+(+$file+==+"-h"+or++$file+==+"--help"+)+{
+++++++++help();
+++++++++exit;
}
if+(+$file+==+"-"+)+$file+=+'php://stdin';

$handle+=+@fopen($file,+"r");
if+($handle)+{
++while+(($data+=+fgetcsv($handle,0,"%7C"))+!==+FALSE)+{
++++$num+=+count($data);
++++for+($c=0;+$c+<+$num;+$c%2B%2B)+{
++++++#+str_replace(+mixed+$search+,+mixed+$replace+,+mixed+$subject+[,+int+&$count+]+)
++++++echo+str_replace("\t",+"\\t",+str_replace("\n",+"\\n",+$data[$c]))+.+"\t";
++++}
++++echo+"\n";
++}
++fclose($handle);
+}+
+else+{
+++echo+"{$argv[0]}:+unable+to+fopen+$argv[1]\n";
+++exit(1);
}
?>|5298586|entityMap^0|2L|A|0|B|5|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|R|$]]

Here's a script for translating a file with pipe-separated values, as described, to one following the simpler conventions of a TSV file. It assumes the availability of a PHP interpreter. If the script is saved as psv2tsv and made executable in a Mac or Linux environment, then <code>psv2tsv -h</code> should offer more details.

Example usage (using <code>&lt;TAB&gt;</code> to indicate a TAB in the output):

<pre><code>$ psv2tsv &lt;&lt;&lt; $'73779087|"UCGr4c0_zShyHbctxJJrJ03w"|"ItsMattSpeaking | SuPra"'
 73779087&lt;TAB&gt;UCGr4c0_zShyHbctxJJrJ03w&lt;TAB&gt;ItsMattSpeaking | SuPra&lt;TAB&gt;

$ psv2tsv &lt;&lt;&lt; $'a|"b|c\t\d"|"e\n"'
a&lt;TAB&gt;b|c\t\d&lt;TAB&gt;e\n&lt;TAB&gt;
</code></pre>

<h3>The script:</h3>

<pre><code>#!/usr/bin/env php

&lt;?php
# Author: pkoppstein at gmail.com 12/2015
# Use at your own risk.
# Input - pipe-separated values along the lines of CSV.
# Translate embedded newline and tab characters.

function help() {
 global $argv;
 echo &lt;&lt;&lt;EOT
Syntax: {$argv[0]} [filepath]

Convert a file or stream of records with pipe-separated values to the
TSV (tab-separated value) format. If no argument is specified, or if
filepath is specified as -, then input is taken from stdin.

The input is assumed to be like a CSV file but with pipe characters
(|) used instead of commas. The output follows the simpler
conventions of TSV files.

Note that each tab in the input is translated to "\\t", and each
embedded newline is translated to "\\n". Each translated record is
then written to stdout. See PHP's fgetcsv for further details.

EOT;
}

$file = ($argc &gt; 1 ) ? $argv[1] : 'php://stdin';

if ( $file == "-h" or $file == "--help" ) {
 help();
 exit;
}
if ( $file == "-" ) $file = 'php://stdin';

$handle = @fopen($file, "r");
if ($handle) {
 while (($data = fgetcsv($handle,0,"|")) !== FALSE) {
 $num = count($data);
 for ($c=0; $c &lt; $num; $c++) {
 # str_replace( mixed $search , mixed $replace , mixed $subject [, int &amp;$count ] )
 echo str_replace("\t", "\\t", str_replace("\n", "\\n", $data[$c])) . "\t";
 }
 echo "\n";
 }
 fclose($handle);
 } 
 else {
 echo "{$argv[0]}: unable to fopen $argv[1]\n";
 exit(1);
}
?&gt;
</code></pre>

I have a data file I am trying to import into redshift (postgress mpp database). I am trying to import into postgres with a '|' delimiter. But some data, has the '|' in the string data itself, for example :

<pre><code>73779087|"UCGr4c0_zShyHbctxJJrJ03w"|"ItsMattSpeaking | SuPra" 
</code></pre>

So I tried this sed command :

<pre><code>sed -i -E "s/(.+|)(.+|)|/\1\2\\|/g" inputfile.txt &gt;outputfile.txt
</code></pre>

Any ideas on what is wrong with the sed command, to replace the | in the last string with a \| escape character so that Redshift will not view this as a delimiter ? Any help is appreciated.

sed command not working ...how to strip a pipe out

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我有一个数据文件，我正在尝试导入到redshift (postgress数据库)。我正在尝试使用分隔符'|‘导入postgres。但是有些数据在字符串数据本身中有'|‘，例如：73779087|"UCGr4c0_zShyHbctxJJrJ03w"|"ItsMattSpeaking | SuPra" 所以我尝试了这个sed命令：sed -i -E "s/(.+|)(.+|)|/\1\2\\|/g" 

问sed命令不起作用...how剥离管道
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问sed命令不起作用...how剥离管道EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问sed命令不起作用...how剥离管道
EN