Sponsored Content
Top Forums Shell Programming and Scripting Meaning of "b" modifier in "sort" command Post 302493342 by wjssj on Wednesday 2nd of February 2011 12:00:15 PM
Old 02-02-2011
Meaning of "b" modifier in "sort" command

I need to sort the following file by the rhdiskpower devices in the last column:

HTML Code:
Total_MB  Free_MB   OS_MB  Name           Failgroup      Library  Label  UDID  Product  Redund   Path
    1024      851    1024  OCRVOT1_0000   OCRVOT1_0000   System                         UNKNOWN  /dev/rhdiskpower1
    1024      853    1024  OCRVOT1_0002   OCRVOT1_0002   System                         UNKNOWN  /dev/rhdiskpower11
    1024      855    1024  OCRVOT1_0001   OCRVOT1_0001   System                         UNKNOWN  /dev/rhdiskpower10
    1024      884    1024  OCRVOT1_0003   OCRVOT1_0003   System                         UNKNOWN  /dev/rhdiskpower2
    1024      884    1024  OCRVOT1_0005   OCRVOT1_0005   System                         UNKNOWN  /dev/rhdiskpower9
    1024      885    1024  OCRVOT1_0004   OCRVOT1_0004   System                         UNKNOWN  /dev/rhdiskpower8
    8192     7563    8192  DBFCRED2_0000  DBFCRED2_0000  System                         UNKNOWN  /dev/rhdiskpower12
    8192     7564    8192  DBFCRED1_0000  DBFCRED1_0000  System                         UNKNOWN  /dev/rhdiskpower3
    8192     7568    8192  DBFCRED1_0001  DBFCRED1_0001  System                         UNKNOWN  /dev/rhdiskpower4
    8192     7569    8192  DBFCRED2_0001  DBFCRED2_0001  System                         UNKNOWN  /dev/rhdiskpower13
   65536    65441   65536  DBFCFLR1_0000  DBFCFLR1_0000  System                         UNKNOWN  /dev/rhdiskpower7
  409600   126488  409600  DBFCDAT1_0002  DBFCDAT1_0002  System                         UNKNOWN  /dev/rhdiskpower5
  409600   126492  409600  DBFCDAT1_0000  DBFCDAT1_0000  System                         UNKNOWN  /dev/rhdiskpower14
  409600   126504  409600  DBFCDAT1_0001  DBFCDAT1_0001  System                         UNKNOWN  /dev/rhdiskpower15
After spending more time than I care to admit, I finally was able to do it with the following sort command:

Code:
sort -k 8.17bn <name of file>

My question is this: The "b" was the critical piece to making this sort work. Without the "b", it sorted numerically by the first column. I've read the sort man pages, and it says that the "b" ignores leading blank characters. Any idea how that relates to what I was trying to do here?

Last edited by wjssj; 02-02-2011 at 01:15 PM..
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies

2. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

3. UNIX for Dummies Questions & Answers

the meaning of "!:*" in "alias foo 'command\!:*' filename"

Hi: How can I remove my own post? Thanks. (2 Replies)
Discussion started by: phil518
2 Replies

4. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

5. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz (8 Replies)
Discussion started by: timmywong
8 Replies

6. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

7. UNIX for Beginners Questions & Answers

Extract delta records using with "comm" and "sort" commands combination

Hi All, I have 2 pipe delimited files viz., file_old and file_new. I'm trying to compare these 2 files, and extract all the different rows between them into a new_file. comm -3 < sort file_old < sort file_new > new_file I am getting the below error: -ksh: sort: cannot open But if I do... (7 Replies)
Discussion started by: njny
7 Replies

8. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

9. AIX

Apache 2.4 directory cannot display "Last modified" "Size" "Description"

Hi 2 all, i have had AIX 7.2 :/# /usr/IBMAHS/bin/apachectl -v Server version: Apache/2.4.12 (Unix) Server built: May 25 2015 04:58:27 :/#:/# /usr/IBMAHS/bin/apachectl -M Loaded Modules: core_module (static) so_module (static) http_module (static) mpm_worker_module (static) ... (3 Replies)
Discussion started by: penchev
3 Replies
file(1) 						      General Commands Manual							   file(1)

Name
       file - determine file type

Syntax
       file [ -c ] [ -f ffile] [ -m mfile] filename ...

Description
       The  command  performs  a  series of tests on each filename argument in an attempt to classify it.  If an argument appears to be ASCII, the
       command examines the first 1024 bytes and tries to guess its language.

       For character special files, part of this classification is information about which devices the system shows  as  active.   In  particular,
       device-specific	information such as controller type and unit, device type and unit, and status (offline, write locked, density, errors) is
       returned. The general categories currently implemented are disk, tape, and terminal devices. The supported terminal devices  include  Local
       Area Terminals (LAT) but not Local Area Network (LAN) pseudo-terminals.

       The  command  uses  the	file to identify files that have some sort of magic number.  A magic number is any numeric or string constant that
       identifies the file containing the constant.  Commentary at the beginning of explains its format.

Options
       -c   Checks the magic file for format errors by printing the internal representation of the magic file.	No file typing is done under -c.

       -f   Interprets the following argument to be a file containing the names of the files to be examined.

       -m   Instructs file to use an alternate magic file.

Restrictions
       It often does a poor job of distinguishing C programs, shell scripts, English text, and ASCII text.

       It does not recognize many programming languages, including Modula, Pascal, and Lisp.

Files
       /usr/lib/file/magic

See Also
       magic(5)

																	   file(1)
All times are GMT -4. The time now is 04:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy