在线求一处理文本SHELL

softiger

有文本内容如下：
43,#2603902,04/20/2016 19:19:47,04/20/2016 20:21:03,J2-P750-E8B-SN06FAC3P,"Error Log Analysis has detected multiple communication errors.  These errors can be caused by attached devices, a switch, a hub, or a SCSI-to-FC convertor.  If connected to a switch, refer to the Storage Area Network (SAN) problem determination procedures for additional problem resolution.  If not connected to a switch, run diagnostics on the attached devices.  If a hub or SCSI-to-FC convertor is attached, refer to the product documentation for problem resolution.",04/20/2016 19:19:47,04/20/2016 19:29:07
50,10001522,04/25/2016 15:43:27,04/25/2016 15:43:27,I2_Server-8233-E8B-SN06E4C5R,ACT04293I Power/Cooling subsystem & control (0x61) reported an error.,04/25/2016 15:43:27,04/25/2016 15:52:08

它的规律是
如果中间的一段用双引号""包含起来的内容，则引号内的内容包含有逗号，
如果中间的内容没用""包含起来，则他的那部分内容不包含有逗号。

导致无法直接用逗号来分割获取需要分割的内容，需求是希望切割的内容是

43,--$1
#2603902,---$2
04/20/2016 19:19:47,--$3
04/20/2016 20:21:03,--$4
J2-P750-E8B-SN06FAC3P,--$5
"Error Log Analysis has detected multiple communication errors.  These errors can be caused by attached devices, a switch, a hub, or a SCSI-to-FC convertor.  If connected to a switch, refer to the Storage Area Network (SAN) problem determination procedures for additional problem resolution.  If not connected to a switch, run diagnostics on the attached devices.  If a hub or SCSI-to-FC convertor is attached, refer to the product documentation for problem resolution.",--$6
04/20/2016 19:19:47,--$7
04/20/2016 19:29:07--$8

50,--$1
10001522,--$2
04/25/2016 15:43:27,--$3
04/25/2016 15:43:27,--$4
I2_Server-8233-E8B-SN06E4C5R,--$5
ACT04293I Power/Cooling subsystem & control (0x61) reported an error.,--$6
04/25/2016 15:43:27,--$7
04/25/2016 15:52:08--$8

使得可以用；分割$1;$2;$3;$4;$5;$6;$7;$8

sunzhiguolu

1. perl -nle '{if (s/("[^"]*"),//){$s5=$1;@a=split(/,/,$_);splice(@a,4,0,$s5)}else{@a=split(/,/,$_)}print join (";",@a)}' urfile

复制代码

haooooaaa

1. awk -vFPAT='([^,]+)|("[^"]+")' '{for(i=1;i<=NF;i++)print $i}' file

复制代码

1. awk -vRS='([^,]+)|("[^"]+")' '{print RT}' file

复制代码

jason680

回复 1# softiger

How about this way with csv function...


$ awk -F, 'function csv(q,n,c){for(n=1;n<=NF;n++){if(!q)c++;$c=q?$c FS $n:$n;if($n~/^"/)q=1;if($n~/"$/){q=0;gsub(/"/,"",$c)}}NF=c}{csv();for(n=1;n<=NF;n++)print $n"--$"n}' file
43--$1
#2603902--$2
04/20/2016 19:19:47--$3
04/20/2016 20:21:03--$4
J2-P750-E8B-SN06FAC3P--$5
Error Log Analysis has detected multiple communication errors.  These errors can be caused by attached devices, a switch, a hub, or a SCSI-to-FC convertor.  If connected to a switch, refer to the Storage Area Network (SAN) problem determination procedures for additional problem resolution.  If not connected to a switch, run diagnostics on the attached devices.  If a hub or SCSI-to-FC convertor is attached, refer to the product documentation for problem resolution.--$6
04/20/2016 19:19:47--$7
04/20/2016 19:29:07--$8
50--$1
10001522--$2
04/25/2016 15:43:27--$3
04/25/2016 15:43:27--$4
I2_Server-8233-E8B-SN06E4C5R--$5
ACT04293I Power/Cooling subsystem & control (0x61) reported an error.--$6
04/25/2016 15:43:27--$7
04/25/2016 15:52:08--$8

   

sunzhiguolu

1. perl -ple '$_=join (";",/".*?"|[^,]+/g)'  file

复制代码

tolilong

cat tt3 | awk -F"\"" '{gsub(",","@@@",$2)}1' | awk -F"," '{gsub("@@@",",",$6);print $1,"\n",$2,"\n",$3,"\n",$4,"\n",$5,"\n",$6,"\n",$7,"\n",$8,"\n"}'
试试这个可行不.

moperyblue

1. sed -r -e{,,,,}'s/,/;/' -e{,}'s/(.*),/\1;/' file

复制代码