Sorting on a Line Item

atl_geek · #1 (**permalink**) 07-26-07, 10:09

I Have a file that contain the following paragraphs. How to sort these paragraphs on "Rows Read" or "Rows Written" or "Overflows"

Table Schema = SYSIBM
Table Name = SYSTABLES
Table Type = Catalog
Data Object Pages = 55
Index Object Pages = 27
LOB Object pages = 1728
Rows Read = 2121
Rows Written = 1
Overflows = 5
Page Reorgs = 0

Table Schema = SYSIBM
Table Name = SYSCOLUMNS
Table Type = Catalog
Data Object Pages = 459
Index Object Pages = 241
Rows Read = 1039
Rows Written = 4
Overflows = 45
Page Reorgs = 1

Table Schema = SYSIBM
Table Name = SYSCOLUMNS
Table Type = Catalog
Data Object Pages = 55
Index Object Pages = 27
LOB Object pages = 1728
Rows Read = 2121
Rows Written = 1
Overflows = 5
Page Reorgs = 0

Table Schema = SYSIBM
Table Name = SYSPROCS
Table Type = Catalog
Data Object Pages = 459
Index Object Pages = 241
Rows Read = 1039
Rows Written = 4
Overflows = 45
Page Reorgs = 1

Thx ahead for the help
Tony

aigles · #2 (**permalink**) 07-26-07, 10:54

Try and adapt the following script :

Code:

awk -v Field='Overflows' '
   BEGIN {
      RS  = "";
      FS  = "\n" 
      Field = toupper(Field) 
      Field_pattern = ".*" Field " = ";
   }
   { 
      Value = toupper($0);
      sub(Field_pattern, "", Value);
      sub(/\n.*/, "", Value);

      for (i=1; i<=NF+1; i++) {
         print Value,NR,i,$i
      }
   }
' input_file |
sort -k1,3n |
cut -f4-

Internet Services

Web Development

Digital Marketing

Consumer Tech