Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Ask questions, find answers and collaborate at work with Stack Overflow for Teams.
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
With awk you can try:
awk
awk -F, -v OFS='|' 'NR==1{print $0} NR>1{$1=$1; $5 = $5 FS $6; print $1,$2,$3,$4,$5,$7,$8}' file Name,Age,Country,ID,Address,Category,DOB John Doe|19|England|3653|Manchester, England|Main Worker|20-05-1995
awk -F, -v OFS='|' 'NR==1{print $0} NR>1{$5 = $5 FS $6; print $1,$2,$3,$4,$5,$7,$8}' file Name,Age,Country,ID,Address,Category,DOB John Doe|19|England|3653|Manchester, England|Main Worker|20-05-1995
awk -F, -v OFS='|' 'NR==1{print $0} NR>1{$1=$1; $5 = $5","$5 FS $6; print $1,$2,$3,$4,$5,$7,$8}' file Name,Age,Country,ID,Address,Category,DOB John Doe|19|England|3653|Manchester, England|Main Worker|20-05-1995
awk -F, -v OFS='|' 'NR==1{print $0} NR>1{$1=$1; $5 = $5"," $6; print $1,$2,$3,$4,$5,$7,$8}' file Name,Age,Country,ID,Address,Category,DOB John Doe|19|England|3653|Manchester, England|Main Worker|20-05-1995
awk -F, -v OFS='|' 'NR>1'NR==1{print $0} NR>1{$1=$1; $5 = $5"," $6; print $1,$2,$3,$4,$5,$7,$8}' file Name,Age,Country,ID,Address,Category,DOB John Doe|19|England|3653|Manchester, England|Main Worker|20-05-1995
awk -F, -v OFS='|' 'NR>1 {$1=$1; $5 = $5"," $6; print $1,$2,$3,$4,$5,$7,$8}' file John Doe|19|England|3653|Manchester, England|Main Worker|20-05-1995
