02-06-2008
Loop through only the distinct values in a file
Datafile has the following data seperated by :
FIELD1:FIELD2:FIELD3
D1:/opt/9.1.9:Y
D2:/opt/10.1.10:Y
D3:/opt/9.1.9:Y
D4:/opt/8.1.8:Y
D5:/opt/8.1.8:Y
D6:/opt/9.1.9:Y
D7:/opt/9.1.9:Y
D8:/opt/10.1.10:Y
D9:/opt/9.1.9:Y
D10:/opt/10.1.10:Y
I want to do some operations only on the distinct values of FIELD2 in a loop.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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
plsurf3d
PLSURF3D(3plplot) PLplot API PLSURF3D(3plplot)
NAME
plsurf3d - Plot shaded 3-d surface plot
SYNOPSIS
plsurf3d(x, y, z, nx, ny, opt, clevel, nlevel)
DESCRIPTION
Plots a three dimensional shaded surface plot within the environment set up by plw3d(3plplot). The surface is defined by the two-dimen-
sional array z[nx][ny], the point z[i][j] being the value of the function at (x[i], y[j]). Note that the points in arrays x and y do not
need to be equally spaced, but must be stored in ascending order. For further details see the PLplot documentation.
Redacted form: plsurf3d(x, y, z, opt, clevel)
This function is not used in any examples.
ARGUMENTS
x (PLFLT *, input)
Pointer to set of x coordinate values at which the function is evaluated.
y (PLFLT *, input)
Pointer to set of y coordinate values at which the function is evaluated.
z (PLFLT **, input)
Pointer to a vectored two-dimensional array with set of function values.
nx (PLINT, input)
Number of x values at which function is evaluated.
ny (PLINT, input)
Number of y values at which function is evaluated.
opt (PLINT, input)
Determines the way in which the surface is represented. To specify more than one option just add the options, e.g. FACETED +
SURF_CONT opt=FACETED: Network of lines is drawn connecting points at which function is defined. opt=BASE_CONT: A contour plot is
drawn at the base XY plane using parameters nlevel and clevel. opt=SURF_CONT: A contour plot is drawn at the surface plane using
parameters nlevel and clevel. opt=DRAW_SIDES: draws a curtain between the base XY plane and the borders of the plotted function.
opt=MAG_COLOR: the surface is colored according to the value of Z; if MAG_COLOR is not used, then the default the surface is colored
according to the intensity of the reflected light in the surface from a light source whose position is set using pllight-
source(3plplot).
clevel (PLFLT *, input)
Pointer to the array that defines the contour level spacing.
nlevel (PLINT, input)
Number of elements in the clevel array.
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 PLSURF3D(3plplot)