My input file contains data in the following format:
1503668542862176 manager=10001|Bounced=999|Analyst=10004|Business Analyst=10005|Programmer=10003
1552024948590636 manager=10001|Bounced=999|Analyst=10004
1551728916565460 Bounced=999|Analyst=10004
1553617087089790 Analyst=10004
1538058487418963 manager=10001|Architect=10002|Analyst=10004
I have to convert second column where every pair of key=value
should be double quoted as "key"="value"
and |
should be replaced with ,
as below using awk
.
1503668542862176 "manager"="10001","Bounced"="999","Analyst"="10004","Business Analyst"="10005","Programmer"="10003"
1552024948590636 "manager"="10001","Bounced"="999","Analyst"="10004"
1551728916565460 "Bounced"="999","Analyst"="10004"
1553617087089790 "Analyst"="10004"
1538058487418963 "manager"="10001","Architect"="10002","Analyst"="10004"