blocks|key|1273125|text|先找到并匹配4"5""6“
将结果传递到下一个语句并替换为4'5‘'6|type|blockquote|depth|inlineStyleRanges|entityRanges|data|1273126|这在perl中是可能的。|unstyled|offset|length|style|CODE|1273127|$+echo+'"123","4"5""6","789"'+%7C+perl+-pe+'s/"\K[%5E,]%2B(?=")/$&=~s%7C"%7C\x27%7Cgr/ge'
"123","4'5''6","789"|code-block|syntax|javascript|1273128|"\K[%5E,]%2B(?=")匹配列内容，省略外部双引号，并使用查找符。|unordered-list-item|1273129|$&=~s%7C"%7C\x27%7Cgr将列内容中的双引号替换为单引号|1273130|使用的e修饰符允许使用Perl代码而不是替换字符串。|1273131|1273132|​|1273133|使用sed时，涉及到杂乱的分支|1273134|$+echo+'"123","4"5""6","789"'+%7C+sed+-E+':a+s/("[%5E,]%2B)"([%5E,]%2B")(,%7C$)/\1\x27\2\3/;+ta'
"123","4'5''6","789"|1273135|:a标记标签|1273136|("[%5E,]%2B)"([%5E,]%2B")(,%7C$)至少用一个内部双引号匹配列内容。|1273137|\1\x27\2\3将内部双引号替换为单引号|1273138|只要有匹配，ta分支就可以标记a|1273139|entityMap^0|0|2|4|0|0|0|D|0|0|F|1|3|1|1|0|0|2|3|0|0|0|2|0|0|M|0|0|A|0|6|2|F|1|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1C|8|@$E|1D|F|1E|G|H]]|9|@]|A|$]]|$1|I|3|J|5|K|7|1F|8|@]|9|@]|A|$L|M]]|$1|N|3|O|5|P|7|1G|8|@$E|1H|F|1I|G|H]]|9|@]|A|$]]|$1|Q|3|R|5|P|7|1J|8|@$E|1K|F|1L|G|H]]|9|@]|A|$]]|$1|S|3|T|5|P|7|1M|8|@$E|1N|F|1O|G|H]]|9|@]|A|$]]|$1|U|3|-4|5|D|7|1P|8|@]|9|@]|A|$]]|$1|V|3|W|5|D|7|1Q|8|@]|9|@]|A|$]]|$1|X|3|Y|5|D|7|1R|8|@$E|1S|F|1T|G|H]]|9|@]|A|$]]|$1|Z|3|10|5|K|7|1U|8|@]|9|@]|A|$L|M]]|$1|11|3|12|5|P|7|1V|8|@$E|1W|F|1X|G|H]]|9|@]|A|$]]|$1|13|3|14|5|P|7|1Y|8|@$E|1Z|F|20|G|H]]|9|@]|A|$]]|$1|15|3|16|5|P|7|21|8|@$E|22|F|23|G|H]]|9|@]|A|$]]|$1|17|3|18|5|P|7|24|8|@$E|25|F|26|G|H]|$E|27|F|28|G|H]]|9|@]|A|$]]|$1|19|3|-4|5|D|7|29|8|@]|9|@]|A|$]]]|1A|$]]

<blockquote>
 find and match 4"5""6 first 
 
 pass the result to next statement and replace to 4'5' '6
</blockquote>

This is possible in <code>perl</code>

<pre><code>$ echo '"123","4"5""6","789"' | perl -pe 's/"\K[^,]+(?=")/$&amp;=~s|"|\x27|gr/ge'
"123","4'5''6","789"
</code></pre>

<ul>
<li><code>"\K[^,]+(?=")</code> match column content, leave out outer double quotes with use of lookarounds</li>
<li><code>$&amp;=~s|"|\x27|gr</code> replace the double quotes found within column content with single quotes

<ul>
<li>The <code>e</code> modifier used allows this usage of Perl code instead of replacement string</li>
</ul></li>
</ul>

 
Workaround with <code>sed</code>, involves messy branches

<pre><code>$ echo '"123","4"5""6","789"' | sed -E ':a s/("[^,]+)"([^,]+")(,|$)/\1\x27\2\3/; ta'
"123","4'5''6","789"
</code></pre>

<ul>
<li><code>:a</code> mark label</li>
<li><code>("[^,]+)"([^,]+")(,|$)</code> matches column content with at least one inner double quote</li>
<li><code>\1\x27\2\3</code> replace the inner double quote with single quote</li>
<li><code>ta</code> branch to label <code>a</code> as long as there is a match</li>
</ul>

blocks|key|1467219|text|echo+'"123","4"5""6","789"'%7Csed+-r+':a;s/%5E([%5E,]%2B,"[%5E,]*)"([%5E"]*",)/\1\x27\2/;ta'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1467220|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|1465455|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1465456|$+sed+':a;s/$"[%5E,"]*$"$[%5E,].*$/\1'\''\2/;ta'+<<<+'"1"23","4"5""6","78"9"'
"1'23","4'5''6","78'9"|code-block|syntax|javascript|1465457|打开双引号并跟随字符直到(但不包括)下一个关闭的"将被捕获并替换为捕获的字符串和一个单引号。|offset|length|style|CODE|1465458|如果替换成功，ta将循环到脚本的开头以进行进一步的替换。|1465459|entityMap^0|0|0|O|1|0|7|2|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@$I|W|J|X|K|L]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

Try this:

<pre><code>$ sed ':a;s/$"[^,"]*$"$[^,].*$/\1'\''\2/;ta' &lt;&lt;&lt; '"1"23","4"5""6","78"9"'
"1'23","4'5''6","78'9"
</code></pre>

Opening double quote and following characters up to(but excluding) next closing <code>"</code> are captured and replaced with captured string and one single quote. 

If replacement succeeds, <code>ta</code> loops to the beginning of the script for further replacements.

blocks|key|272853|text|您可以使用以下awk方法：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|272854|echo+'"123","4"5""6","789"'+%7C+awk+-F,+'{OFS=",";+$2="\""gensub(/\042/,+"\047","g",+substr($2,+2,+length($2)-2))"\"";}1'|code-block|syntax|javascript|272855|产出：|272856|"123","4'5''6","789"|272857|解释：|272858|-F,+(OFS=",")+-处理,作为现场分离器|272859|"\042"+-双引号八进制码|272860|"\047"+-单引号ASCII八进制码|272861|substr($2,+2,+length($2)-2)+-从第二个字段中提取子字符串，除了尾随双引号，即4"5""6|272862|gensub(/\042/,+"\047","g",+[target])+-用目标字符串中的单引号替换所有双引号|272863|entityMap^0|7|3|0|0|0|0|0|0|3|5|7|H|1|0|0|6|0|0|6|0|0|R|1G|6|0|0|10|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|15|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|16|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|17|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|18|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|19|8|@$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]|$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|S|3|T|5|6|7|1G|8|@$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|U|3|V|5|6|7|1J|8|@$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|W|3|X|5|6|7|1M|8|@$9|1N|A|1O|B|C]|$9|1P|A|1Q|B|C]]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|1R|8|@$9|1S|A|1T|B|C]]|D|@]|E|$]]|$1|10|3|-4|5|6|7|1U|8|@]|D|@]|E|$]]]|11|$]]

You may use the following <code>awk</code> approach:

<pre><code>echo '"123","4"5""6","789"' | awk -F, '{OFS=","; $2="\""gensub(/\042/, "\047","g", substr($2, 2, length($2)-2))"\"";}1'
</code></pre>

The output:

<pre><code>"123","4'5''6","789"
</code></pre>

<hr>

Explanation:

<code>-F,</code> (<code>OFS=","</code>) - treating <code>,</code> as field separator

<code>"\042"</code> - double quote ASCII octal code

<code>"\047"</code> - single quote ASCII octal code

<code>substr($2, 2, length($2)-2)</code> - extracting substring from the second field except trailing double quotes, i.e. <code>4"5""6</code>

<code>gensub(/\042/, "\047","g", [target])</code> - substitutes all double quotes with single quotes within the target string

blocks|key|272870|text|另一项awk建议：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|272871|echo+'"123","4"5""6","789"'+%7Cawk+'{sub(/4"5""/,"4\47"5"\47\47")}1'

"123","4'5''6","789"|code-block|syntax|javascript|272872|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|$]]

Another awk proposal: 

<pre><code>echo '"123","4"5""6","789"' |awk '{sub(/4"5""/,"4\47"5"\47\47")}1'

"123","4'5''6","789"
</code></pre>

I have a csv file whose fields are delimited by double quote (") and comma (,), e.g:

<pre><code>"123","4"5""6","789"
</code></pre>

However, there may be some double quote (") within the data, i.e. <code>4"5""6</code> which I need to transform into single quote ('), i.e.

I need to transform 

<pre><code>"123","4"5""6","789"
</code></pre>

to

<pre><code>"123","4'5''6","789"
</code></pre>

I've tried something like

<pre><code>sed "s/$\",\"$$\"\|[^\(","$]\)*$\",\"$/\1'\3/"g 
</code></pre>

but <code>(\"\|[^$","$]\)*</code> only

match <code>"</code> OR not <code>","</code>

but may be I need something like 

match <code>"</code> AND not <code>","</code>

<hr>

Another approach may be perform sequential sed, i.e.

<ol>
<li>find and match 4"5""6 first</li>
<li>pass the result to next statement and replace to 4'5' '6</li>
</ol>

But for both ways, I don't know exactly how to do it.

<hr>

Although I can replace all <code>"</code> into <code>'</code> first and then re-format my csv but it seems to be costly, i.e.
<code>sed -i -e "s/\"/'/g" -e "s/','/\",\"/g" -e "s/^'/\"/g" -e "s/'$/\"/g" myFile.csv</code>

sed: replace a pattern between two similar patterns, i.e. ( replace " to ' between two "," )

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我有一个csv文件，其字段由双引号(")和逗号(，)分隔，例如："123","4"5""6","789"但是，数据中可能有一些双引号(")，即需要转换为单引号(')的4"5""6，即我需要改变"123","4"5""6","789"至"123","4'5''6","789"我试过sed "s/$\",\"$\(\"...

问sed:在两个相似的模式之间替换一个模式，即(替换“to‘在两个”之间"，“)
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问sed:在两个相似的模式之间替换一个模式，即(替换“to‘在两个”之间"，“)EN