Skip to main content
2 of 8
added 244 characters in body

Bash: changing csv column

1,,,,ivan petrov,,67, 2,2,,,Vasia pupkin,director,8, 3,,,,john Lenon,,, 

The task is to change it to:

1,,,,Ivan Petrov,,123, 2,2,,,Vasia Pupkin,director,34, 3,,,,John Lenon,,, 

Name and Surname should start with upper letter

#!/bin/bash while IFS="," read line do ns=$(echo $line | awk -F, '{print $5}') name=$(echo $ns | awk '{print $1}') surname=$(echo $ns | awk '{print $2}') ns=$(echo ${name^} ${surname^}) awk -v nm="$ns" 'BEGIN{FS=OFS=","}{$5=nm}1' accnew.csv done < <(tail -n +2 accnew.csv) > 1new.csv 

That's my code,but it doesnt;t work correctly