Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sort and summarise between patterns
Top Forums Shell Programming and Scripting Sort and summarise between patterns Post 303026177 by disedorgue on Wednesday 21st of November 2018 10:50:54 AM
Old 11-21-2018
It's a little few hard and the result is little few different (highest number then highest aphabetic so) :
Code:
awk '/^-- Current Database:/ {A--}{print A" "$0}' /tmp/file.txt | LC_COLLATE=C sort | uniq -c | sed '/-- Current Database:/s/[0-9]\+/Z/' | LC_COLLATE=C  sort -rn -k2,2 | sed 's/ *Z -[0-9]* //;s/  \+\|-[0-9]\+//g'

Regards.
This User Gave Thanks to disedorgue For This Post:
mac-arrow
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Searching patterns in 1 file and deleting all lines with those patterns in 2nd file

Hi Gurus, I have a file say for ex. file1 which has 3500 lines in it which are different account numbers and another file (file2) which has 230000 lines in it. I want to read all the lines in file1 and delete all those lines from file2 which has that same pattern as in file1. I am not quite... (4 Replies)
Discussion started by: toms
4 Replies

2. 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

3. 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

4. Shell Programming and Scripting

Looking for a short way to summarise many sed commands

Hello, I have a large number of sed commands that I execute one after the other, simply because I don't know if there's a shorter way to do it. I hope someone can help me save some time :-) These are my commands: 1.) remove all " in the file: sed -e 's/\"//g' file 2.) insert ( and... (3 Replies)
Discussion started by: Bloomy
3 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 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

7. 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

8. Shell Programming and Scripting

Find matched patterns and print them with other patterns not the whole line

Hi, I am trying to extract some patterns from a line. The input file is space delimited and i could not use column to get value after "IN" or "OUT" patterns as there could be multiple white spaces before the next digits that i need to print in the output file . I need to print 3 patterns in a... (3 Replies)
Discussion started by: redse171
3 Replies

9. Shell Programming and Scripting

Bash - Find files excluding file patterns and subfolder patterns

Hello. For a given folder, I want to select any files find $PATH1 -f \( -name "*" but omit any files like pattern name ! -iname "*.jpg" ! -iname "*.xsession*" ..... \) and also omit any subfolder like pattern name -type d \( -name "/etc/gconf/gconf.*" -o -name "*cache*" -o -name "*Cache*" -o... (2 Replies)
Discussion started by: jcdole
2 Replies

10. 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

LEARN ABOUT DEBIAN

linux-version

LINUX-VERSION(1)					      General Commands Manual						  LINUX-VERSION(1)

NAME

       linux-version - operate on Linux kernel version strings

SYNOPSIS

       linux-version compare VERSION1 OP VERSION2

       linux-version sort [--reverse] [VERSION1 VERSION2 ...]

       linux-version list [--paths]

DESCRIPTION

       linux-version operates on Linux kernel version strings as reported by uname -r and used in file and directory names.  These version strings
       do not follow the same rules as Debian package version strings and should not be compared as such or as arbitrary strings.

       compare VERSION1 OP VERSION2
	      Compare version strings, where OP is a binary operator. linux-version returns success (zero result) if the  specified  condition	is
	      satisfied, and failure (nonzero result) otherwise.  The valid operators are: lt le eq ne ge gt

       sort [--reverse] [VERSION1 VERSION2 ...]
	      Sort the given version strings and print them in order from lowest to highest.  If the --reverse option is used, print them in order
	      from highest to lowest.

	      If no version strings are given as arguments, the version strings will instead be read from standard input, one per line.  They  may
	      be suffixed by arbitrary text after a space, which will be included in the output.  This means that, for example:

	      linux-version list --paths | linux-version sort --reverse

	      will list the installed versions and corresponding paths in order from highest to lowest version.

       list [--paths]
	      List kernel versions installed in the customary location.  If the --paths option, show the corresponding path for each version.

AUTHOR

       linux-version and this manual page were written by Ben Hutchings as part of the Debian linux-base package.

								   30 March 2011						  LINUX-VERSION(1)
All times are GMT -4. The time now is 11:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy