Please help me with a BASH code which targets a particular column in a csv file and converts it to upper. For instance, if file_a.csv has the following columns:
man,woman,boy,girl
woman,man,boy,girl
boy,girl,man,woman
girl,boy,woman,man
I want to convert column 2 to upper in order to have:
man,WOMAN,boy,girl
woman,MAN,boy,girl
boy,GIRL,man,woman
girl,BOY,woman,man
Thanks for your help
CodePudding user response:
You can accomplish this with sed:
sed 's/[^,]*/\U&/2' file_a.csv
- This will replace the 2nd string with with zero or more non-comma characters with it's uppercase equivalent