Find unique values but only in column 1 Post: 302987592

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Need to find only unique values for a given tag across the files

Need to find only unique values for a given tag across the files: For eg: Test1: <Tag1>aaa</Tag1> <Tag2>bbb</Tag2> <Tag3>ccc</Tag3> Test2: <Tag1>aaa</Tag1> <Tag2>ddd</Tag2> <Tag3>eee</Tag3> Test3: <Tag1>aaa</Tag1> <Tag2>ddd</Tag2> <Tag3>eee</Tag3> Test4:

2. Shell Programming and Scripting

Concatenating column values with unique id into single row

Hi, I have a table in Db2 with data say id_1 phase1 id_1 phase2 id_1 phase3 id_2 phase1 id_2 phase2 I need to concatenate the values like id_1 phase1,phase2,phase3 id_2 phase1,phase2 I tried recursive query but in vain as the length of string to be concatenated in quite long. ...

3. Shell Programming and Scripting

return a list of unique values of a column from csv format file

Hi all, I have a huge csv file with the following format of data, Num SNPs, 549997 Total SNPs,555352 Num Samples, 157 SNP, SampleID, Allele1, Allele2 A001,AB1,A,A A002,AB1,A,A A003,AB1,A,A ... ... ... I would like to write out a list of unique SNP (column 1). Could you...

4. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the...

5. Shell Programming and Scripting

Count frequency of unique values in specific column

Hi, I have tab-deliminated data similar to the following: dot is-big 2 dot is-round 3 dot is-gray 4 cat is-big 3 hot in-summer 5 I want to count the frequency of each individual "unique" value in the 1st column. Thus, the desired output would be as follows: dot 3 cat 1 hot 1 is...

6. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this?

7. Shell Programming and Scripting

Extracting unique values of a column from a feed file

Hi Folks, I have the below feed file named abc1.txt in which you can see there is a title and below is the respective values in the rows and it is completely pipe delimited file ,. ...

8. UNIX for Dummies Questions & Answers

Unique values in a row sum the next column in UNIX

Hi would like to ask you guys any advise regarding my problem I have this kind of data file.txt 111111111,20 111111111,50 222222222,70 333333333,40 444444444,10 444444444,20 I need to get this file1.txt 111111111,70 222222222,70 333333333,40 444444444,30 using this code I can...

9. Shell Programming and Scripting

awk to filter out lines containing unique values in a specified column

Hi, I have multiple files that each contain four columns of strings: File1: Code: 123 abc gfh 273 456 ddff jfh 837 789 ghi u4u 395 File2: Code: 123 abc dd fu 456 def 457 nd 891 384 djh 783 I want to compare the strings in Column 1 of File 1 with each other file and Print in...

10. Shell Programming and Scripting

Count number of unique values in each column of array

What is an efficient way of counting the number of unique values in a 400 column by 1000 row array and outputting the counts per column, assuming the unique values in the array are: A, B, C, D In other words the output should look like: Value COL1 COL2 COL3 A 50 51 52...

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)