08-16-2016
Hi.
Quote:
Originally Posted by
Nik44
Thanks for the reponses! I've gone for the more straight forward cut option as it provides the desired output.
However I forgot to add to this question... Is there a way of refining this output further so that it will only count a record of that group where field four is "1" and where field five is "Y"? I realise in the example supplied it would still show the exact same count.
You're welcome.
My rule of thumb is that when a specific content of a specific field needs to be examined, manipulated, etc., then I reach for
awk first (
perl second) because the field-separating facilities are very good.
If you can certify that the contents of fields 4 and 5 are unique to the content of all fields in a line, then you may be able to use the suggestion from rovf to use
grep, because
grep will consider the content of the entire line without regard to fields. Otherwise, an
awk solution seems like the best approach.
Best wishes ... cheers, drl
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i am using the c shell on solaris.
directories i'm working with:
ls -1d DIV*
DIV_dental/
DIV_ibc/
DIV_ifc/
DIV_index/
DIV_pharm/
DIV_sectionI/
DIV_sectionI-title/
DIV_sectionI-toc/
DIV_sectionII-title/
DIV_sectionII-toc/
DIV_standing/
DIV_standing-toc/
DIV_title/
DIV_vision/ (1 Reply)
Discussion started by: effigy
1 Replies
2. UNIX for Dummies Questions & Answers
Hi all,
I have a set data as shown below, and i would like to eliminate the name that no children - boy and girl. What is the appropriate command can i use(other than grep)? Please assist...
My input:
name sex marital status children - boy children - girl ... (3 Replies)
Discussion started by: 793589
3 Replies
3. UNIX for Advanced & Expert Users
Hi all,
I have input lines like below:
A;100;Paris;City;10;0;0
A;100;Paris;City;0;10;0
A;100;Paris;City in Europe;0;0;20
B;101;London;City;20;0;0
B;101;London;City;0;20;0
B;101;London;City in Europe;0;0;40
I need to group the above lines to:
A;100;Paris;City in Europe;10;10;20... (4 Replies)
Discussion started by: andy2000
4 Replies
4. Shell Programming and Scripting
I have a text file in this format.
Group: AAA
Notes: IP : 11.11.11.11
#User xxxxxxxxx
#Password aaaaaaaaaaaaaaaa
Group: AAA
Notes: IP : 11.11.11.22
#User yyyyyyyyyyyyy
#Password bbbbbbbbbbbbb (8 Replies)
Discussion started by: anil510
8 Replies
5. UNIX for Dummies Questions & Answers
How do you do grouping in grep? Here's how I tried it at first:
egrep 'qualit(y|ies)' /usr/share/dict/words
-bash: syntax error near unexpected token `('
I'm using GNUgrep, and I found this on their site. grep regular expression syntax
So I tried this:
egrep 'qualit\(y\|ies\)'... (2 Replies)
Discussion started by: sudon't
2 Replies
6. Shell Programming and Scripting
Hi all,
I am using following command:
perl program.pl input.txt output.txt CUTOFF 3 > groups_3.txt
containing program.pl, two files (input.txt, output.txt) and getting output in groups_3.txt:
But, I wish to have 30 files corresponding to each CUTOFF ranging from 0 to 30 using the same... (1 Reply)
Discussion started by: bioinfo
1 Replies
7. Shell Programming and Scripting
Hi guys,
I am a complete newbie to unix and have been tasked with creating a script to group the following data (file) by hourly slots so that I can count the transactions completed within the peak hour.
I am not sure how to group data like this in unix. Can anyone please help?
Here is an... (1 Reply)
Discussion started by: MrMidas
1 Replies
8. Shell Programming and Scripting
awk 'FNR==NR {a; next} $NF in a' genes.txt refseq_exons.txt > output.txt
I can not figure out how to group the same name in $4 together.
Basically, all the SKI together in separate rows and all the TGFB2. Thank you :).
chr1 2160133 2161174 SKI
chr1 218518675 218520389 TGFB2... (1 Reply)
Discussion started by: cmccabe
1 Replies
9. Shell Programming and Scripting
Hi All,
I want to read the input file and store the output in the Output file. I pasted the sample Input and Output file below. Help me with this.
Input file
=================================
ITEM1 AAAAA 1
ITEM1 BBBBB 1
ITEM1 CCCCC 1
ITEM2 AAAAA 5
ITEM2 CCCCC 4... (1 Reply)
Discussion started by: humaemo
1 Replies
10. Shell Programming and Scripting
Hi can you please help with the below ?
source file:
Column1,Column2,Column3,Column4
abc,123,dir1/FXX/F19,1
abc,123,dir1/FXX/F20,1
abc,123,dir1/FXX/F23,2
abc,123,dir1/FXX/C25,2
abc,123,dir1/FXX/X25,2
abc,123,dir1/FXX/A23,3
abc,123,dir1/FXX/Z25,3
abc,123,dir1/FXX/Y25,4
I want to... (3 Replies)
Discussion started by: paul1234
3 Replies
groups(1) General Commands Manual groups(1)
NAME
groups - Displays your group membership
SYNOPSIS
groups [user]
DESCRIPTION
The groups command writes to standard output the groups to which you or the specified user belong. The Tru64 UNIX operating system allows
a user to belong to many different groups at the same time.
Your primary group is specified in the /etc/passwd file. Once you are logged in, you can change your active group with the newgrp shell
command (see sh). When you create a file, its group ID is that of your active group.
Other groups that you belong to are specified in the /etc/group file. If you belong to more than one group, you can access files belonging
to any of those groups without changing your primary group ID. These are called your concurrent groups.
NOTES
The /etc/passwd and /etc/group files must be on the same node.
EXAMPLES
To determine your group membership, enter: groups
The groups to which you belong will be displayed. For example: devel prod
FILES
Contains group information. Contains user information.
SEE ALSO
Commands: csh(1), ksh(1), sh(1)
Functions: initgroups(3), setgroups(2)
groups(1)