regex - 用 SED 将数字用双引号括起来

Question

我有一个简单的需求，我输入了likeL

4,23139,,"XYZ" 

在一个文本文件中，我需要这样的输出

"4","23139","","ARCMsgEnum".

我写的命令在某些情况下工作正常:

sed 's/[0-9]*[0-9]/"&"/g' inputTestData.txt | sed s/,,/,\"\",/g 

但有些行的输入是时间戳:

4,23139,,"XYZ","2008-09-04 08:11:33.51 AM"

所以期望的输出是:

"4","23139","","XYZ","2008-09-04 08:11:33.51 AM"

但是上面的命令给我的输出是这样的:

"4","23139","","XYZ",""2008"-"09"-"04" "08":"11":"33"."46" AM"

Answer 1

以下内容可能对您有用:

sed -e 's/"//g' -e 's/[^,]*/"&"/g' inputfile

这将首先去除引号，然后在逗号内的部分内插入引号。

举个例子:

$ echo 4,23139,,\"XYZ\",\"2008-09-04 08:11:33.51 AM\" | sed -e 's/"//g' -e 's/[^,]*/"&"/g'
"4","23139","","XYZ","2008-09-04 08:11:33.51 AM"