08-14-2008
Thanks !!
Hi Guys...
Thank you(era and cherry) very much for the solutions...I could use the array solution for my requirement.
Well, how abt incorporating a specific condition in AWK to retrieve such records which DONT meet the criteria as mentioned in my original post?...any thoughts ?...
-Anduzzi
10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. 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
5. 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
6. UNIX for Advanced & Expert Users
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
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
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
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
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 OPENSOLARIS
getdgrp
getdgrp(1M) System Administration Commands getdgrp(1M)
NAME
getdgrp - lists device groups which contain devices that match criteria
SYNOPSIS
/usr/sbin/getdgrp [-ael] [criteria]... [dgroup]...
DESCRIPTION
getdgrp generates a list of device groups that contain devices matching the given criteria. The criteria is given in the form of expres-
sions.
OPTIONS
The following options are supported:
-a Specifies that a device must match all criteria to be included in the list generated by this command. The option has no effect if no
criteria are defined.
-e Specifies that the list of device groups on the command line should be excluded from the list generated by this command. Without the
-e option the named device groups are included in the generated list. The flag has no effect if no devices are defined.
-l Specifies that all device groups (subject to the -e option and the dgroup list) should be listed even if they contain no valid
device members. This option has no affect if criteria is specified on the command line.
OPERANDS
The following operands are supported:
criteria Defines criteria that a device must match before a device group to which it belongs can be included in the generated list.
Specify criteria as an expression or a list of expressions which a device must meet for its group to be included in the list
generated by getdgrp. If no criteria are given, all device groups are included in the list.
Devices must satisfy at least one of the criteria in the list. However, the -a option can be used to define that a "logical
and" operation should be performed. Then, only those groups containing devices which match all of the criteria in a list will
be included.
There are four possible expressions types which the criteria specified in the criteria argument may follow:
attribute=value Selects all device groups with a member whose attribute attribute is defined and is equal to value.
attribute!=value Selects all device groups with a member whose attribute attribute is defined and does not equal value.
attribute:* Selects all device groups with a member which has the attribute attribute defined.
attribute!:* Selects all device groups with a member which does not have the attribute attribute defined.
See putdev(1M) for a complete listing and description of available attributes.
dgroup Defines a set of device groups which should be included in or excluded from the generated list. Device groups that are defined
and which contain devices matching the criteria are included.
If the -e option is used, this list defines a set of device groups to be excluded. When the -e option is used and criteria
is also defined, the generated list will include device groups containing devices which match the criteria and are not in the
command line list.
EXIT STATUS
The following exit values are returned:
0 Successful completion of the task.
1 Command syntax was incorrect, invalid option was used, or an internal error occurred.
2 Device table or device group table could not be opened for reading.
FILES
/etc/device.tab
/etc/dgroup.tab
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
devattr(1M), getdev(1M), putdev(1M), putdgrp(1M), attributes(5)
SunOS 5.11 5 Jul 1990 getdgrp(1M)