Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk to print distinct col values
Top Forums Shell Programming and Scripting Awk to print distinct col values Post 302224751 by anduzzi on Thursday 14th of August 2008 12:45:10 AM
Old 08-14-2008
Cud someone help me on this pls?...

Thanks !!!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Getting Distinct values from second field in a file....

Hi I have a pipe delimited file. I am trying to grab the DISTINCT value from the second field. The file is something like: 1233|apple|ron 1234|apple|elephant 1235|egg|man the output I am trying to get from second field is apple,egg (apple coming only once) Thanks simi (4 Replies)
Discussion started by: simi28
4 Replies

2. Shell Programming and Scripting

grep distinct values

this is a little more complex than that. I have a text file and I need to find all the distinct words that appear in a line after the word TABLESPACE when I grep for just the word tablespace, I get: how do i parse this a little better so i have a smaller file to read? This is just an... (4 Replies)
Discussion started by: guessingo
4 Replies

3. UNIX for Dummies Questions & Answers

distinct values of all the fields

I am a beginner to scripting, please help me in this regard. How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (1 Reply)
Discussion started by: vukkusila
1 Replies

4. Shell Programming and Scripting

distinct values of all the fields

I am a beginner to scripting, please help me in this regard. How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (2 Replies)
Discussion started by: vukkusila
2 Replies

5. Shell Programming and Scripting

average of distinct values with awk

Hi guys, I am not an expert in shell and I need help with awk command. I have a file with values like 200 1 1 200 7 2 200 6 3 200 5 4 300 3 1 300 7 2 300 6 3 300 4 4 I need resulting file with averages of... (3 Replies)
Discussion started by: saif
3 Replies

6. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

7. UNIX for Dummies Questions & Answers

count number of distinct values in each column with awk

Hi ! input: A|B|C|D A|F|C|E A|B|I|C A|T|I|B As the title of the thread says, I would need to get: 1|3|2|4 I tried different variants of this command, but I don't manage to obtain what I need: gawk 'BEGIN{FS=OFS="|"}{for(i=1; i<=NF; i++) a++} END {for (b in a) print b}' input ... (2 Replies)
Discussion started by: beca123456
2 Replies

8. Shell Programming and Scripting

Find distinct values

Hi, I have two files of the following format file1 chr1:345-456 chr2:123-456 chr2:455-678 chr3:456-789 chr3:444-555 file2 chr1:345-456 chr2:123-456 chr3:456-789 output (2 Replies)
Discussion started by: jacobs.smith
2 Replies

9. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies

10. Emergency UNIX and Linux Support

Read values in each col starting 3rd row.Print occurrence value.

Hello Friends, Hope all are doing fine. Here is a tricky issue. my input file is like this 07 10 14 20 21 03 15 27 30 32 01 10 11 19 30 02 06 14 15 17 01 06 20 25 29 Logic: 1. Please print another column as "0-0-0-0-0" for the first and second rows. 2. Read the first column... (4 Replies)
Discussion started by: jacobs.smith
4 Replies

LEARN ABOUT DEBIAN

plcont

PLCONT(3plplot) 						    PLplot API							   PLCONT(3plplot)

NAME

       plcont - Contour plot

SYNOPSIS

       plcont(z, nx, ny, kx, lx, ky, ly, clevel, nlevel, pltr, pltr_data)

DESCRIPTION

       Draws a contour plot of the data in z[nx][ny], using the nlevel contour levels specified by clevel. Only the region of the array from kx to
       lx and from ky to ly is plotted out.  A transformation routine pointed to by pltr with a pointer pltr_data for additional data required	by
       the transformation routine is used to map indices within the array to the world coordinates.  See the following discussion of the arguments
       and the PLplot documentation for more information.

       Redacted form: [PLEASE UPDATE! ONLY PERL INFO IS LIKELY CORRECT!] F95: plcont(z, kx, lx, ky, ly, clevel, tr?) or plcont(z, kx, lx, ky,  ly,
       clevel,	xgrid, ygrid) Java: pls.cont(z, kx, lx, ky, ly, clevel, xgrid, ygrid) Perl/PDL: plcont(z, kx, lx, ky, ly, clevel, pltr, pltr_data)
       Python: plcont2(z, kx, lx, ky, ly, clevel)

       This function is used in examples 9,14,16,22.

ARGUMENTS

       z (PLFLT **, input)
	      Pointer to a vectored two-dimensional array containing data to be contoured.

       nx, ny (PLINT, input)
	      Physical dimensions of array z.

       kx, lx (PLINT, input)
	      Range of x indices to consider.

       ky, ly (PLINT, input)
	      Range of y indices to consider.

       clevel (PLFLT *, input)
	      Pointer to array specifying levels at which to draw contours.

       nlevel (PLINT, input)
	      Number of contour levels to draw.

       pltr (void (*) (PLFLT, PLFLT, PLFLT *, PLFLT *, PLPointer) , input)
	      Pointer to function that defines transformation between indices in array z and the world coordinates (C only).  Transformation func-
	      tions  are  provided in the PLplot library: pltr0(3plplot) for identity mapping, and pltr1(3plplot) and pltr2(3plplot) for arbitrary
	      mappings respectively defined by one- and two-dimensional arrays.  In addition, user-supplied routines for the transformation can be
	      used  as	well.	Examples of all of these approaches are given in the PLplot documentation. The transformation function should have
	      the form given by any of pltr0(3plplot), pltr1(3plplot), or pltr2(3plplot). Note that unlike plshades(3plplot)  and  similar  PLplot
	      functions  which have a pltr argument, plcont requires that a transformation function be provided in the C interface.  Leaving  pltr
	      NULL will result in an error.

       pltr_data (PLPointer, input)
	      Extra parameter to help pass information to pltr0(3plplot), pltr1(3plplot), pltr2(3plplot), or whatever routine that  is	externally
	      supplied.

AUTHORS

       Geoffrey  Furnish  and  Maurice LeBrun wrote and maintain PLplot.  This man page was automatically generated from the DocBook source of the
       PLplot documentation, maintained by Alan W. Irwin and Rafael Laboissiere.

SEE ALSO

       PLplot documentation at http://plplot.sourceforge.net/resources.

								   August, 2012 						   PLCONT(3plplot)
All times are GMT -4. The time now is 06:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy