Hi Akshay,

This is giving me all the columns but they all are coming in the same cell.
I am redirecting the output to a .xls file as below:

Code:

perl -lape '$F[0] = join(" ", $F[0] =~ m/(.{3})(\d{1,2})(\d{4})(\d{1,2}:\d{1,2})(.{2})/);  $_ = join(" ",@F) '  file.txt > file.xls

Earlier when i was using the sed command given by Don it was coming perfectly in the .xls file

Code:

sed 's/\(...\)\(..\)\(....\)\(.*\)\(.[^[:space:]]\)[[:space:]]*/\1 \2 \3 \4 \5/' file.txt > file.xls

only one problem i was getting there was the output was coming like below:

Code:

jan 16 2014 13:17PM abc def g hi
jan 16 2014 3:17PM abc def g hi
jan 16 2014 3:17PM abc def g hi
jan 16 2014 3:17PM abc def g hi
jan 16 2014 3:17PM abc def g hi

It was giving space before the last two letters instead of giving space before PM.
Can we edit the code given by Don? The SED command mentioned above.