Numbering by field


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Numbering by field
# 8  
Old 11-20-2014
Optimized code

Code:
awk '
BEGIN { z=1}
{ 
ink[$4]++;
inz[z]=$0;
in4[z]=$4;
inlast[z]=$5;
z++;
}
END { 

cur="";prev=""
for(l=1;l<=z;l++)
  {
  cur=in4[l]
  if(cur!=prev)
    {
    new=1
    }
  if(inlast[l]=="-")
  {
  print inz[l] " " ink[in4[l]]--
  }
  if(inlast[l]=="+")
  print inz[l] new++
    
  prev=in4[l]
  }
}
' input.txt

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing numbering from last character

Hi, I have a file test.txt, below the contents: SCDE1 SF9 STR1D2 SREDF21 FRED STER2R4 I want to remove only the last character if it is the number, so the output should as below: SCDE SF STR1D SREDF2 FRED STER2R (4 Replies)
Discussion started by: khchong
4 Replies

2. Shell Programming and Scripting

Incremental numbering?

Would it be possible for a script to duplicate a file and incrementally number it? File in: XXX_007_0580_xxxx_v0016.aep File out: XXX_007_0580_xxxx_v0017.aep If someone knows of a way I'd love to see it. Thanks! (7 Replies)
Discussion started by: scribling
7 Replies

3. Shell Programming and Scripting

help with numbering a file

Hi, All I need to do is number a file. The file looks like this > JJJJJJJJJJJJJJJJJJJJJ > JKJKJKKKKKKJJJ > MMMMYKKKJKKK what I want to do is number it so that theres a numerical value beside the >. >1 JJJJJJJJJJJJJJJJJJJJJ >2 JKJKJKKKKKKJJJ (2 Replies)
Discussion started by: kylle345
2 Replies

4. UNIX for Dummies Questions & Answers

Numbering the rows

If I a list of components, is there anyway to number (like automatically have: 1,2,3,...) the rows of my data? (1 Reply)
Discussion started by: cosmologist
1 Replies

5. Shell Programming and Scripting

Numbering duplicates

Hi, I have this large file and sometimes there are duplicates and I want to basically find them and figure how many there are. So I have a file with multiple columns and the last column (9) has the duplicates. eg. yan tar tar man ban tan tub tub tub Basically what I want to... (6 Replies)
Discussion started by: kylle345
6 Replies

6. Shell Programming and Scripting

Numbering Lines

Hello everyone, I want get numbered lines from a file. and i can do it with: sed = file.txt | sed "/./N; s/\n/ /" | sed -n "5,7p" but the output that i get is something similar to: 5 line5 6 line6 7 line7 and i want something like this (with 2points after the number): 5:... (6 Replies)
Discussion started by: vibra
6 Replies

7. UNIX for Advanced & Expert Users

numbering blanks

hello i'm trying to figure out how to number a blank line. For instance this : sed '/./=' file | sed '/./N; s/\n/ /' gives me 1 aaaa 2 bbbbbb 4 cccccc 5 ffkkkfff 6 ffsdfdfs I would like something like this: 1 aaaaa 2 3 bbbbbb 4 5 cccccc And so... (6 Replies)
Discussion started by: wisher115
6 Replies

8. Shell Programming and Scripting

Numbering

I'm trying to do a script that will look for a log file if it is already there change the name to another name. I.E if log.0 is there rename to log.1 rename log.1 to log.2 rename log.2 to log.3 and so on. Only thing is I got no idea where or what is the best command to use for this? ... (3 Replies)
Discussion started by: merlin
3 Replies

9. UNIX for Dummies Questions & Answers

Numbering!

Just a shot question... how to make 1,2,3,...999 into the form of 001,002,003....999 (3 digits) Thanks.... (9 Replies)
Discussion started by: biglemon
9 Replies

10. UNIX for Dummies Questions & Answers

numbering of process

:confused: How does UNIX handle the numbering of processes? (2 Replies)
Discussion started by: tweety111
2 Replies
Login or Register to Ask a Question
ODBC_RESULT(3)								 1							    ODBC_RESULT(3)

odbc_result - Get result data

SYNOPSIS
mixed odbc_result (resource $result_id, mixed $field) DESCRIPTION
Get result data PARAMETERS
o $result_id - The ODBC resource. o $field - The field name being retrieved. It can either be an integer containing the column number of the field you want; or it can be a string containing the name of the field. RETURN VALUES
Returns the string contents of the field, FALSE on error, NULL for NULL data, or TRUE for binary data. EXAMPLES
The first call to odbc_result(3) returns the value of the third field in the current record of the query result. The second function call to odbc_result(3) returns the value of the field whose field name is "val" in the current record of the query result. An error occurs if a column number parameter for a field is less than one or exceeds the number of columns (or fields) in the current record. Similarly, an error occurs if a field with a name that is not one of the fieldnames of the table(s) that is(are) being queried. Example #1 odbc_result(3) examples <?php $item_3 = odbc_result($Query_ID, 3); $item_val = odbc_result($Query_ID, "val"); ?> NOTES
Field indices start from 1. Regarding the way binary or long column data is returned refer to odbc_binmode(3) and odbc_longreadlen(3). PHP Documentation Group ODBC_RESULT(3)