目前,我正在处理具有如下行为的数据
"Halo A","Test B","Yes, This is test","No Problem, we can test, right","{Okay}","Test oneTest two","One,Two,Three",",","Done","","Test (1,2,3)","Yes","",
"1", ""Test 1. Try, 2.Again, and 3. Done"",",期望数据可以是这样的,
"Halo A","Test B","Yes, This is test","No Problem, we can test, right","{Okay}","Test oneTest two","One,Two,Three","","","Done","","Test (1,2,3)","Yes","",
"1","Test 1. Try, 2.Again, and 3. Done","",我正在尝试使用下面的sed
s/\(|"[^"|]*\)"\([^"|]*"\)/\1\2/g但是在遇到()和之后,sed似乎不工作了。
"Halo A","Test B","Yes, This is test","No Problem, we can test, right","{Okay}","Test oneTest two","One,Two,Three","","","Done","","Test (1,2,3)",""Yes"","",
"1",""Test 1. Try, 2.Again, and 3. Done"","",发布于 2021-09-30 13:27:29
要匹配嵌套引号,您需要确定匹配的目标,例如嵌套引号。
sed -E 's/"("[A-Za-z0-9., ]*")"/\1/g' input_file如您所见,该命令只针对引号中的引号,并且只提取嵌套引号,而不提取主引号。
$ sed -E 's/"("[A-Za-z0-9., ]*")"/\1/g' input_file
"Halo A","Test B","Yes, This is test","No Problem, we can test, right","{Okay}","Test oneTest two","One,Two,Three","","","Done","","Test (1,2,3)","Yes","",https://stackoverflow.com/questions/69392426
复制相似问题