I am having a CSV file containing 3000+ lines in the following format:
R1C1, ABC123abc, R1C3 R2C1, DEFG456defg, R2C3 R3C1, HIJKL789hijkl, R3C3
I need to remove all the capital letters from the second column of the file so that it reads as follows:
R1C1, 123abc, R1C3 R2C1, 456defg, R2C3 R3C1, 789hijkl, R3C3
How can this be done?