Help to switch dates from a file

Shell Programming and Scripting
1

Hi.
I need some assistance with a file who at the end i must import to EXCEL.

The problem is that i have a file with this inside:

Output:
JOBID START TIME END TIME ELAPSED CPU
------------------------------------------------------------
AVERAGE: no data no data
737516 11-14 01:00 11-14 01:04 00:04:38 00:01:06
827490 11-13 01:00 11-13 01:13 00:13:05 00:02:33
729186 11-12 01:00 11-12 01:00 00:00:40 00:00:32
737438 11-11 01:00 11-11 01:01 00:01:06 00:00:39
770088 11-10 01:00 11-10 01:20 00:20:10 00:02:17

and as you can see, the " 11-10 " is November Ten and so on.
If i import this to Excel , he read's everithing wrong and put's " 11-Out
" . I'm portuguese and it puts 11 of October . It's wrong.

So i was thinking to switch from " MM-DD " to " DD-MM " on Unix and then import to Excel. This must be done on the 2 columns with date.

Can anyone help ?

Regards,

2

I would have thought that Excel supports a whole range of date formats, I suppose the trick is to tell it which one to use while importing.

3

is this what you want:

[yogeshs@PS0814 temp]$ cat job_file
737516 11-14 01:00 11-14 01:04 00:04:38 00:01:06
827490 11-13 01:00 11-13 01:13 00:13:05 00:02:33
729186 11-12 01:00 11-12 01:00 00:00:40 00:00:32
737438 11-11 01:00 11-11 01:01 00:01:06 00:00:39
770088 11-10 01:00 11-10 01:20 00:20:10 00:02:17
[yogeshs@PS0814 temp]$ perl -pi -e 's/(\d{2})-(\d{2})/\2-\1/g' job_file
[yogeshs@PS0814 temp]$
[yogeshs@PS0814 temp]$ cat job_file
737516 14-11 01:00 14-11 01:04 00:04:38 00:01:06
827490 13-11 01:00 13-11 01:13 00:13:05 00:02:33
729186 12-11 01:00 12-11 01:00 00:00:40 00:00:32
737438 11-11 01:00 11-11 01:01 00:01:06 00:00:39
770088 10-11 01:00 10-11 01:20 00:20:10 00:02:17
[yogeshs@PS0814 temp]$