Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Loop through only the distinct values in a file
Top Forums Shell Programming and Scripting Loop through only the distinct values in a file Post 302165059 by ag79 on Wednesday 6th of February 2008 04:47:13 PM
Old 02-06-2008
you have to be more specific here.. assuming this file is delimited by colons, u can get the distinct values by cut -f2 -d':' filename and pipe output to | sort | uniq

if u want it in loop the u can use
for i in `cut -f2 -d':' filenmae |sort|uniq`
do
ls -l $i #do something
done

its untested code so u may hv to tweak a little
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk to print distinct col values

Hi Guys... I am newbie to awk and would like a solution to probably one of the simple practical questions. I have a test file that goes as: 1,2,3,4,5,6 7,2,3,8,7,6 9,3,5,6,7,3 8,3,1,1,1,1 4,4,2,2,2,2 I would like to know how AWK can get me the distinct values say for eg: on col2... (22 Replies)
Discussion started by: anduzzi
22 Replies

2. 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

3. 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

4. Shell Programming and Scripting

Select distinct values from a flat file

Hi , I have a similar problem. Please can anyone help me with a shell script or a perl. I have a flat file like this fruit country apple germany apple india banana pakistan banana saudi mango india I want to get a output like fruit country apple ... (7 Replies)
Discussion started by: smalya
7 Replies

5. 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

6. 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

7. 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

8. 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

9. 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

10. Shell Programming and Scripting

Need distinct values from command in a script

Hello, I am using below command srvctl config service -d cmdbut cmdbut_01 (P):/devoragridcn_01/app/oracle> srvctl config service -d cmdbut Service name: boms10.world Service is enabled Server pool: cmdbut_boms10.world Cardinality: 1 Disconnect: false Service role: PRIMARY Management... (7 Replies)
Discussion started by: Vishal_dba
7 Replies

LEARN ABOUT DEBIAN

plbin

PLBIN(3plplot)							    PLplot API							    PLBIN(3plplot)

NAME

       plbin - Plot a histogram from binned data

SYNOPSIS

       plbin(nbin, x, y, opt)

DESCRIPTION

       Plots  a  histogram consisting of nbin bins.  The value associated with the i'th bin is placed in x[i], and the number of points in the bin
       is placed in y[i].  For proper operation, the values in x[i] must form a strictly increasing sequence.  By default, x[i] is  the  left-hand
       edge  of  the  i'th  bin.  If opt=PL_BIN_CENTRED is used, the bin boundaries are placed midway between the values in the x array.  Also see
       plhist(3plplot) for drawing histograms from unbinned data.

       Redacted form:  General: plbin(x, y, opt) Perl/PDL: plbin(nbin, x, y, opt) Python: plbin(nbin, x, y, opt)

       This function is not used in any examples.

ARGUMENTS

       nbin (PLINT, input)
	      Number of bins (i.e., number of values in x and y arrays.)

       x (PLFLT *, input)
	      Pointer to array containing values associated with bins.	These must form a strictly increasing sequence.

       y (PLFLT *, input)
	      Pointer to array containing number of points in bin.  This is a PLFLT (instead of PLINT) array so as to allow histograms	of  proba-
	      bilities, etc.

       opt (PLINT, input)
	      Is a combination of several flags: opt=PL_BIN_DEFAULT: The x represent the lower bin boundaries, the outer bins are expanded to fill
	      up the entire x-axis and bins of zero height are simply drawn.  opt=PL_BIN_CENTRED|...: The bin boundaries are to be midway  between
	      the  x  values.  If  the values in x are equally spaced, the values are the center values of the bins.  opt=PL_BIN_NOEXPAND|...: The
	      outer bins are drawn with equal size as the ones inside.	opt=PL_BIN_NOEMPTY|...: Bins with zero height are not drawn  (there  is  a
	      gap for such bins).

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 						    PLBIN(3plplot)
All times are GMT -4. The time now is 07:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy