Shell Programming and Scripting

This file has a delimiter "," so wanted to know if my code is correct? or can it be modified to make it simpler?

Hi.

What happens if you treat the new file as still having only two fields? ... cheers, drl

Before
qa,2007-04-29 01:02:02.440
df,2007-04-28 01:02:02.446
gf,2007-04-29 01:02:15.113
df,2007-05-29 01:02:15.113
jh,2007-04-28 09:09:04.939
lk,2007-04-29 09:09:04.952
uj,2007-05-29 09:09:05.886
ki,2007-04-29 09:09:05.887
gy,2007-04-28 09:00:49.066

This is how my file looks before...
need it to be sort like below
After
df,2007-04-28 01:02:02.446
gy,2007-04-28 09:00:49.066
jh,2007-04-28 09:09:04.939
qa,2007-04-29 01:02:02.440
gf,2007-04-29 01:02:15.113
lk,2007-04-29 09:09:04.952
ki,2007-04-29 09:09:05.887
df,2007-05-29 01:02:15.113
uj,2007-05-29 09:09:05.886

should be sorted in ascending order of year mothe date and for each date the time should be in ascending order...the dont need any sorting for the first field that is the field before ","

Hi.

OK, you've already posted how the file should look --- the important part is what you wrote at the bottom of the post:
so I think you are getting closer.

How did I set up my sort for two fields?

You want to essentially ignore the first 3 characters of the first field.

I suggest you look carefully at the man page again to see how you might do that. Didn't you have a sort of that kind in one of your posts?

I'll look in perhaps tomorrow to see how you did. Best wishes ... cheers, drl

I figured it out..

Hi, unics.

OK, that's good to hear.

It's usually considered good form to post your answer so that other people who have a similar problem can also be helped ... cheers, drl

I have already posted the code above...that is working fine...was just looking out for something shorter :-)