Find top N values for field X based on field Y's value Post: 302320919

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

awk - Summing a field based on another field

So, I need to do some summing. I have an Apache log file with the following as a typical line: 127.0.0.1 - frank "GET /apache_pb.gif HTTP/1.0" 200 2326 Now, what I'd like to do is a per-minute sum. So, I can have awk tell me the individual minutes, preserving the dates(since this is a...

2. Shell Programming and Scripting

adding field values if field matches

hi i have file as below , i want to add duplicate records like bell_bb to one record with valuve as 15 ( addition of both ) any oneline awk script to achive this ? header 0 CAMPAIGN_NAME 1 Bell_BB 14 Bell_MONTHLY 803 SOLO_UNBEATABLE 644 Bell_BB 1 Bell_MONTHLY 25 SOLO_UNBEATABLE...

3. UNIX for Dummies Questions & Answers

Please help me to find out maximum value of a field based on grouping of other fields.

Please help me to find out maximum value of a field based on grouping of other fields, as we do in SQL. Like in SQL if we are having below records : Client_Name Associate_Name Date1 Value C1111 A1111 2012-01-17 10 C1111 A1111 ...

4. Shell Programming and Scripting

Find a blank field and replace values to NA

Hi All, i have a file like col1 col2 col3 13 24 NA 12 13 14 11 12 13 14 22 NA 18 26 NA in this file if i found "NA" other values in the line are also replace by NA Could you help me!

5. Shell Programming and Scripting

awk to update value in field based on another field

In the tab-delimeted input file below I am trying to use awk to update the value in $2 if TYPE=ins in bold, by adding the value of HRUN= in italics. In the below since in line 1 TYPE=ins the 117282541 value in $2 has 6 added because that is the value of HRUN=. Hopefully the awk is a start but I...

6. Shell Programming and Scripting

awk to adjust coordinates in field based on sequential numbers in another field

I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines. If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line...

7. UNIX for Beginners Questions & Answers

Print lines based upon unique values in Nth field

For some reason I am having difficulty performing what should be a fairly easy task. I would like to print lines of a file that have a unique value in the first field. For example, I have a large data-set with the following excerpt: PS003,001 MZMWR/ L-DWD// * PS003,001...

8. Shell Programming and Scripting

Compute average based on field values

Im looking for a way to average the values in field 14 (when field 2 is equal to 2016) and fields 3 and 4 (when field 2 is equal to 2017). Any help is appreciated. 001001 2016 33.22 38.19 48.07 51.75 59.77 67.68 70.86 72.21 66.92 53.67 42.31 40.15 001001 2017 ...

9. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

Hi, So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple...

LEARN ABOUT PHP

udm_get_res_field

UDM_GET_RES_FIELD(3)							 1						      UDM_GET_RES_FIELD(3)

udm_get_res_field - Fetch a result field

SYNOPSIS

       string udm_get_res_field (resource  $res, int  $row, int  $field)

DESCRIPTION

	Fetch a mnoGoSearch result field.

PARAMETERS

	      o $res
		-$res - a link to result identifier, received after call to udm_find(3).

	      o $row
		-$row - the number of the link on the current page. May have values from 0 to $UDM_PARAM_NUM_ROWS-1.

	      o $field
		-$field - field identifier, may have the following values:

		     o UDM_FIELD_URL - document URL field

		     o UDM_FIELD_CONTENT - document Content-type field (for example, text/html).

		     o UDM_FIELD_CATEGORY  - document category field. Use udm_cat_path(3) to get full path to current category from the categories
		       tree root. (This parameter is available only in PHP 4.0.6 or later).

		     o UDM_FIELD_TITLE - document title field.

		     o UDM_FIELD_KEYWORDS - document keywords field (from META KEYWORDS tag).

		     o UDM_FIELD_DESC - document description field (from META DESCRIPTION tag).

		     o UDM_FIELD_TEXT - document body text (the first couple of lines to give an idea of what the document is about).

		     o UDM_FIELD_SIZE - document size.

		     o UDM_FIELD_URLID - unique URL ID of the link.

		     o UDM_FIELD_RATING - page rating (as calculated by mnoGoSearch).

		     o UDM_FIELD_MODIFIED - last-modified field in unixtime format.

		     o UDM_FIELD_ORDER - the number of the current document in set of found documents.

		     o UDM_FIELD_CRC - document CRC.

RETURN VALUES

       udm_get_res_field(3) returns result field value on success, FALSE on error.

PHP Documentation Group 												      UDM_GET_RES_FIELD(3)