Hi there I have a text file with several fields separated by ";" as follow :
5466-43;5466;JOAN;LIGA;LIGA ESPANOLA;43;DEP LA CORUNA - OSASUNA;10/01/10 17:00
5466-44;5466;CARLES;LIGA;LIGA ESPANOLA;44;MALAGA - ATHL BILBAO;10/01/10 17:00
5466-45;5466;FAB;LIGA;LIGA ESPANOLA;45;REAL MADRID - MAIORCA;10/01/10 19:00
5466-46;5466;MARCEL;LIGA;LIGA ESPANOLA;46;TENERIFE - BARCELLONA;10/01/10 21:00
What I need to do is to split last column in two parts adjusting the data format into dd/mm/yyyy so that I should have :
466-43;5466;JOAN;LIGA;LIGA ESPANOLA;43;DEP LA CORUNA - OSASUNA;10/01/2010;17:00
5466-44;5466;CARLES;LIGA;LIGA ESPANOLA;44;MALAGA - ATHL BILBAO;10/01/2010;17:00
5466-45;5466;FAB;LIGA;LIGA ESPANOLA;45;REAL MADRID - MAIORCA;10/01/2010;19:00
5466-46;5466;MARCEL;LIGA;LIGA ESPANOLA;46;TENERIFE - BARCELLONA;10/01/2010;21:00
Than I need to save the above result in a new file.
I have tried with something with awk but no way to have the result as I wish.
Thank you in advance for your help
Greetings