Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

sort help

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sort help
# 1  
Old 04-29-2007
sort help
Before
2007-04-29 01:02:02.440
2007-04-28 01:02:02.446
2007-04-29 01:02:15.113
2007-05-29 01:02:15.113
2007-04-28 09:09:04.939
2007-04-29 09:09:04.952
2007-05-29 09:09:05.886
2007-04-29 09:09:05.887
2007-04-28 09:00:49.066

After
2007-04-28 01:02:02.446
2007-04-28 09:00:49.066
2007-04-28 09:09:04.939
2007-04-29 01:02:15.113
2007-04-29 09:09:03.965
2007-04-29 09:09:04.952
2007-05-29 01:02:15.113
2007-05-29 09:09:05.886


How do i sort this in ascending order of year month date and for each date the timestamps should be in ascending order...
# 2  
Old 04-29-2007
Code:
tr -s ':' ' ' < filename | tr -s '-' ' ' | sort | \
awk '{ printf("%s-%s-%s %s:%s:%s\n", $1, $2, $3, $4, $5, $6) }'

output
Code:
2007-04-28 01:02:02.446
2007-04-28 09:00:49.066
2007-04-28 09:09:04.939
2007-04-29 01:02:02.440
2007-04-29 01:02:15.113
2007-04-29 09:09:04.952
2007-04-29 09:09:05.887
2007-05-29 01:02:15.113
2007-05-29 09:09:05.886

# 3  
Old 04-29-2007
Hi.

The before and after files are different in length.

Because you have the columns so nicely lined up, you should be able to use sort with just a few keys:
Code:
#!/bin/sh

# @(#) s1       Demonstrate sort for date and time.

# sample:
# 2007-04-29 01:02:02.440
# Everything is in columns, so just sort on key 1 and then key 2.

sort -k1,2 -k2 data1 |
tee data2

if ! cmp data2 results.txt
then
        echo
        echo " Results from diff:"
        echo
        diff -y -W72 --suppress-common-lines data2 results.txt
else
        echo
        echo " Files are identical."
fi

exit 1

Producing:
Code:
% ./s1
2007-04-28 01:02:02.446
2007-04-28 09:00:49.066
2007-04-28 09:09:04.939
2007-04-29 01:02:02.440
2007-04-29 01:02:15.113
2007-04-29 09:09:04.952
2007-04-29 09:09:05.887
2007-05-29 01:02:15.113
2007-05-29 09:09:05.886

 Files are identical.

where the file results.txt is from jim's post, data1 is your input data, and data2 is the sort output ... cheers, drl
# 4  
Old 04-29-2007
thx
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

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

If the data is in the above format how can we sort?
# 5  
Old 04-30-2007
Hi, unics.

You've seen two solutions to a similar problem.

How would you go about analyzing this problem after consulting man pages?

What commands and options would you use?

Show us some of your attempts and work ... cheers, drl
# 6  
Old 04-30-2007
Hi
I have tried

sort -t"," -k2.1,2.4n -k2.6,2.7n -k2.9,2.10n -k2.12,2.13n -k2.15,2.16n -k2.18,2.19n -k2.21,2.23n

but somehow seems to work sometimes..dont know whats the prob..anything that needs to be corrected?
# 7  
Old 04-30-2007
Hi.

OK, it looks like you are working with fields and parts of fields.

How is this file different from the first one? ... cheers, drl
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Use sort to sort numerical column

How to sort the following output based on lowest to highest BE? The following sort does not work. $ sort -t. -k1,1n -k2,2n bfd.txt BE31.116 0s 0s DOWN DAMP BE31.116 0s 0s DOWN DAMP BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies

2. UNIX for Beginners Questions & Answers

Difference of Sort -n -k2 -k3 & Sort -n -k2,3

Hi, Could anyone kindly show me a link or explain the difference between sort -n -k2 -k3 & sort -n -k2,3 Also, if I like to remove the row with repetition at both $2 and $3, Can I safely use sort -u -k2 -k3 Example; 100 20 30 100 20 30 So, both $2 and $3 are same and I... (2 Replies)
Discussion started by: Indra2011
2 Replies

3. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

Hi Experts, I have a filelist collected from another server , now want to sort the output using date/time stamp filed. - Filed 6, 7,8 are showing the date/time/stamp. Here is the input: #---------------------------------------------------------------------- -rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies

4. Shell Programming and Scripting

Help with sort word and general numeric sort at the same time

Input file: 100%ABC2 3.44E-12 USA A2M%H02579 0E0 UK 100%ABC2 5.34E-8 UK 100%ABC2 3.25E-12 USA A2M%H02579 5E-45 UK Output file: 100%ABC2 3.44E-12 USA 100%ABC2 3.25E-12 USA 100%ABC2 5.34E-8 UK A2M%H02579 0E0 UK A2M%H02579 5E-45 UK Code try: sort -k1,1 -g -k2 -r input.txt... (2 Replies)
Discussion started by: perl_beginner
2 Replies

5. Shell Programming and Scripting

Alternate to sort --random-sort

sort --random-sort The full command is path=`find /testdir -maxdepth 1 -mindepth 1 -type d | ***Some sort of sort function*** | head -1` I have a list I want to randomly sort. It works fine in ubuntu but on a 'osx lion' sort dosen't have the --random-sort option. I don't want to... (5 Replies)
Discussion started by: digitalviking
5 Replies

6. Shell Programming and Scripting

Help to sort out... Possible use of sort command

I have an input like 4.3.6.66 4.3.6.67 4.3.6.70 4.3.6.25 4.3.6.15 4.3.6.54 4.3.6.44 4.3.6.34 4.3.6.24 4.3.6.14 4.3.6.53 4.3.6.43 4.3.6.49 4.3.6.33 4.3.6.52 4.3.6.19 4.3.6.58 4.3.6.42 (5 Replies)
Discussion started by: dnam9917
5 Replies

7. Shell Programming and Scripting

Is it Possible to sort a list of hexadecimal numbers using "sort" command?

Hello Everybody :) !!!. i have question in mind, is it possible to sort a list of hexadecimal numbers using "sort" command? (9 Replies)
Discussion started by: Kesavan
9 Replies

8. UNIX for Advanced & Expert Users

Script to sort the files and append the extension .sort to the sorted version of the file

Hello all - I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
Discussion started by: pankaj80
3 Replies

9. Shell Programming and Scripting

How to Sort Floating Numbers Using the Sort Command?

Hi to all. I'm trying to sort this with the Unix command sort. user1:12345678:3.5:2.5:8:1:2:3 user2:12345679:4.5:3.5:8:1:3:2 user3:12345687:5.5:2.5:6:1:3:2 user4:12345670:5.5:2.5:5:3:2:1 user5:12345671:2.5:5.5:7:2:3:1 I need to get this: user3:12345687:5.5:2.5:6:1:3:2... (7 Replies)
Discussion started by: daniel.gbaena
7 Replies

10. Shell Programming and Scripting

sort

I check the man page but I still cannot see what this command is supposed to do sort +5 -6 <file> It just seems to sort the file as normal?? Thanks Calypso (3 Replies)
Discussion started by: Calypso
3 Replies
Login or Register to Ask a Question