hi,
i have various csv files, the file format is as follows
Entry: "1",4,2010/08/15-10-00-00.01,,"E",,,,,,,,,120,0,"M4_","C","KEW-011-5337140-20100916163456-540097","1234567890","N N 0 ",,,"NUK 800100200",,,"NN",,,,,,,,,,,,"0000000001|0001|20150401 10203001|001","6151|886|9024|N|N|N|0033
in this i want to change the 3rd field(2010/08/15-10-00-00.01) if the user enters a particular date it must change to that in all records...
Eg:
if he enters 201209 all records in all files must have the year and month of the 3rd field changed (2012/09/15-10-00-00.01)..can anyone tell me how to do it??
should i use perl or awk or anything.....