Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Count unique column
Top Forums UNIX for Beginners Questions & Answers Count unique column Post 302997589 by nans on Wednesday 17th of May 2017 03:56:54 AM
Old 05-17-2017
Ah yes, thank you. Though the output looks

Code:
Colum1 Colum2 Colum3 Colum4 Column5 Column6
1.1 100 100 a b^M 1
1.1 100 100 a c^M 1
1.2 200 205 a d^M 1
1.3 300 301 a y^M 2
1.4 400 410 a b^M 1
1.5 500 510 a c^M  1
1.5 500 500 a d^M  1
1.5 500 500 a y^M  2

But that should be okay, I can always use sed to remove the ^M characters. Thank you.
Last edited by Don Cragun; 05-17-2017 at 06:10 AM.. Reason: Change QUOTE tags to CODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to count unique strings

How do I count the total number of unique strings from a file using Perl? Any help is appreciated.. (6 Replies)
Discussion started by: my_Perl
6 Replies

2. Shell Programming and Scripting

Unique count from flat file

Hello Guys I have a flat file with '|~|' delimited When I use to record count using below command awk -FS"+" ' {print $colno}' filename | wc -l the count is fine But when I am trying to find the unique number of record the o/p is always 1 awk -FS"+" ' {print $colno}'... (11 Replies)
Discussion started by: Pratik4891
11 Replies

3. Shell Programming and Scripting

awk pattern match and count unique in column

Hi all I have a need of searching some pattern in file by month and then count unique records D11 G11 R11 -------> Pattern available in file S11 Jan$1 to $5 column contains some records in which I want to find unique for this purpose I have written script like below awk '/Jan/ ||... (4 Replies)
Discussion started by: nex_asp
4 Replies

4. 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... (5 Replies)
Discussion started by: owwow14
5 Replies

5. Shell Programming and Scripting

awk to count using each unique value

Im looking for an awk script that will take the unique values in column 5, then print and count the unique values in column 6. CA001011500 11111 11111 -9999 201301 AAA CA001012040 11111 11111 -9999 201301 AAA CA001012573 11111 11111 -9999 201301 BBB CA001012710 11111 11111 -9999 201301... (4 Replies)
Discussion started by: ncwxpanther
4 Replies

6. Shell Programming and Scripting

Count of unique lines in field 4

When I use the below awk to count the unique lines in $4 for the input it seems to work. The answer is 3 because $4 is only unique 3 times in all the entries. However, when I use the same on actual data I get 56,536 and I know the answer should be 56,548. My question is there a better way to... (8 Replies)
Discussion started by: cmccabe
8 Replies

7. Shell Programming and Scripting

Count occurrence of column one unique value having unique second column value

Hello Team, I need your help on the following: My input file a.txt is as below: 3330690|373846|108471 3330690|373846|108471 0640829|459725|100001 0640829|459725|100001 3330690|373847|108471 Here row 1 and row 2 of column 1 are identical but corresponding column 2 value are... (4 Replies)
Discussion started by: angshuman
4 Replies

8. Shell Programming and Scripting

Print count of unique values

Hello experts, I am converting a number into its binary output as : read n echo "obase=2;$n" | bc I wish to count the maximum continuous occurrences of the digit 1. Example : 1. The binary equivalent of 5 = 101. Hence the output must be 1. 2. The binary... (3 Replies)
Discussion started by: H squared
3 Replies

9. UNIX for Beginners Questions & Answers

Count unique words

Dear all, I would like to know how to list and count unique words in thousands number of text files. Please help me out thanks in advance (9 Replies)
Discussion started by: imranrasheedamu
9 Replies

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... (16 Replies)
Discussion started by: Geneanalyst
16 Replies

LEARN ABOUT PHP

printer_create_font

PRINTER_CREATE_FONT(3)							 1						    PRINTER_CREATE_FONT(3)

printer_create_font - Create a new font

SYNOPSIS

       resource  printer_create_font (string  $face, int  $height, int	$width, int  $font_weight, bool  $italic, bool	$underline, bool  $strike-
       out, int  $orientation)

DESCRIPTION

	The function creates a new font and returns a handle to it. A font is used to draw text. For an example see printer_select_font(3).

PARAMETERS

	      o $face
		-$face must be a string specifying the font face.

	      o $height
		-$height specifies the font height.

	      o $width
		-$width specifies the font width.

	      o $font_weight
		- The $font_weight specifies the font weight (400 is normal), and can be one of the following predefined constants.

		     o PRINTER_FW_THIN: sets the font weight to thin (100).

		     o PRINTER_FW_ULTRALIGHT: sets the font weight to ultra light (200).

		     o PRINTER_FW_LIGHT: sets the font weight to light (300).

		     o PRINTER_FW_NORMAL: sets the font weight to normal (400).

		     o PRINTER_FW_MEDIUM: sets the font weight to medium (500).

		     o PRINTER_FW_BOLD: sets the font weight to bold (700).

		     o PRINTER_FW_ULTRABOLD: sets the font weight to ultra bold (800).

		     o PRINTER_FW_HEAVY: sets the font weight to heavy (900).

	      o $italic
		-$italic can be TRUE or FALSE, and sets whether the font should be italic.

	      o $underline
		-$underline can be TRUE or FALSE, and sets whether the font should be underlined.

	      o $strikeout
		-$strikeout can be TRUE or FALSE, and sets whether the font should be stroked out.

	      o $orientaton
		-$orientation specifies a rotation.

RETURN VALUES

	Returns a font handle on success or FALSE on error.

PHP Documentation Group 												    PRINTER_CREATE_FONT(3)
All times are GMT -4. The time now is 10:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy