Hi Im having trouble manipulating some data in a CSV file
As below I have a CSV file that has a header row and I need to change the data in the Title,State,Country columns to Title Caps and then save the updates but leave the other columns unchanged.
Example Data:
First Name,Surname,Email Address,Initials,Position No,Title,State,Country,Position Number,Second Name,Preferred Name,Gender,Position Start,Position End,Joined,Birth Date
"0001","John","Smith","jsmith@email.com.au","","CUS003","MR","VIC","AUSTRALIA","Customer Service Agent","","","M",31 Mar 2018,
Afterwards Id like the file to display like below:
First Name,Surname,Email Address,Initials,Position No,Title,State,Country,Position Number,Second Name,Preferred Name,Gender,Position Start,Position End,Joined,Birth Date
"0001","John","Smith","jsmith@email.com.au","","CUS003","Mr","Vic","Australia","Customer Service Agent","","","M",31 Mar 2018,
Thanks in advance for any assistance.