Nicola Gambaro's questions

This a sample of my input file:

22/12/1999,conductivity,42,uS/cm
06/01/2000,conductivity,22,uS/cm
26/01/2000,conductivity,26,uS/cm
09/02/2000,conductivity,32,uS/cm
23/02/2000,conductivity,33,uS/cm

I would like to reformat it so that it matches another database. The first column needs to say COMPTON in all lines, a sixth needs to say PRECIPITATION, and a seventh NOT APPLICABLE.

I probably need to use some awk function but am unsure.

I've got a series of CSV files whose second field is dates:

R.OUSE BOURTON MILL,2000-03-22T14:50:00,Ammoniacal Nitrogen as N,0.03,mg/l

How can I change the date format into DD/MM/YYYY for all files? The measurement time is not needed.

Thank you so much