Shell Programming and Scripting

awk 'BEGIN{FS=OFS="'"}{for(i=1;i<=NF;i++) if($i ~ /user.*,user.*|Immediate Backup|whatever/) gsub(/,/,"Xox9870563xoX",$i)};1' infile >outfile

awk 'BEGIN{FS=OFS="'"}{for(i=1;i<=NF;i++) if($i ~ /user.*user/) sub(",","Xox9870563xoX",$i)};1'  vo
>
>
>

awk 'BEGIN{FS=OFS="'"}{for(i=1;i<=NF;i++) if($i ~ /user.*,user.*|Immediate Backup|whatever/) gsub(/,/,"Xox9870563xoX",$i)};1' vo

user.*,user.*|Immediate Backup|whatever/)

sed "s/\([\'][^\'][^\']*\),\([^\'][^\']*\)/\1Xox9870563xoX\2/" yourfile

awk '{OFS=NR%2?",":"Xox9870563xoX";$1=$1}1' RS="\'" FS=,  ORS="\'" yourfile

# cat tst
a,b,'jklfds','a,b,a,c','f','g','c','c,d'
a,b,'jklfds','a,b,a,c','f','g','c','c,d'
# awk '{OFS=NR%2?",":"#";$1=$1}1' RS="\'" FS=,  ORS="\'" tst
a,b,'jklfds','a#b#a#c','f','g','c','c#d'
a,b,'jklfds','a#b#a#c','f','g','c','c#d'
'# awk '{OFS=NR%2?",":"Xox9870563xoX";$1=$1}1' RS="\'" FS=,  ORS="\'" tst
a,b,'jklfds','aXox9870563xoXbXox9870563xoXaXox9870563xoXc','f','g','c','cXox9870563xoXd'
a,b,'jklfds','aXox9870563xoXbXox9870563xoXaXox9870563xoXc','f','g','c','cXox9870563xoXd'
'#

awk '{OFS=NR%2?",":"Xox9870563xoX";$1=$1}1' RS="\'" FS=,  ORS="\'" vo
awk: cmd. line:1: warning: escape sequence `\'' treated as plain `''

# awk -F"'[,']" -vc="Xox9870563xoX" -vx="'" -vxx="," '{for(i=1;i<=NF;i++)if($i~x ".*" xx){l=split($i,a,xx x);;for(j=1;j<l;j++)
lx=lx?lx a[j]:a[j] xx x;;gsub(xx,c,a[l]);;$i=lx a[l] x xx;printf "%s",$i;lx=""}else if(i!=NF)printf "%s%s",$i,x xx;else printf "%s",$i}END{print ""}' file
(1,NULL,'FULL',1,0,'Immediate BackupXox9870563xoXDatabase backup successfullXox9870563xoXLicense backup successfullXox9870563xoXCompleted backup operation successfully',5,'COMPLETED','BACKUP',2,100,NULL,NULL,NULL,NULL,'2011-04-04 05:33:33');