Search Results

Hi Balav,
can we break this in two steps.
by sed and awk.
sed -i 's/"//g' file
awk 'BEGIN{print "user,phone,duration,login,ip_address";RS="";OFS=",";FS="="} { print $2 OFS $4 OFS $6 OFS $8 OFS...

If the records are separated by two newlines with no spaces and the fields are always in the same order, one could also try:
awk 'FNR==1{print $1,$3,$5,$9}{print $2,$4,$6,$10}' FS='[="\n]*' OFS=,...

Hello Balav,

Please use code tags as per forum rules for all commands/codes/Inputs which you are using into your posts. Following may help you in same.

awk -F"=" '/^user/ && A{A=A ORS;B=""}...

Hello Bala,

Apologies for not seeing that part, could you please try following and let me know if this helps you.

awk -F"=" '/^login/{next} /^user/ && A{A=A ORS;B=""}{B=B?B OFS...

Another approach:
awk -F\" 'BEGIN{print "Cust-Number,Cust-Name,Cust-Town,Cust-Purchase"}
/hobby/ || !NF{next}
/purchase/{print $2; next}
{printf $2 ","}
' file

Let me quote Don Cragun for you:

Howsoever, tryawk -F= '
BEGIN {HD = "Cust-Number,Cust-Name,Cust-Town,Cust-purchase"
print HD
HDCnt = split (HD, HDArr, ",")
...