how to parse with awk (using different fields), then group by a field? Post: 302501139

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk-Group count of field

Hi, Suppose if i am having a file with following records as given below. 5555 6756 5555 4555 4555 6767 how can i get the count of each record using AWK. Eg:5555 count should be 2 4555 count should be 2 6767 count should be 1 ...

2. Shell Programming and Scripting

Using AWK to parse a delimited field

Hi everyone! How can I parse a delimited field using AWK? For example, if I have lastName#firstName or lastName*firstName. I'd like an AWK script that would return lastName and then another that would return firstName? Is this possible?

3. Shell Programming and Scripting

awk - print all fields except for last field

How do I print all the fields of a record except for the $(NF) field?

4. UNIX for Dummies Questions & Answers

keeping last record among group of records with common fields (awk)

input: ref.1;rack.1;1 #group1 ref.1;rack.1;2 #group1 ref.1;rack.2;1 #group2 ref.2;rack.3;1 #group3 ref.2;rack.3;2 #group3 ref.2;rack.3;3 #group3 Among records from same group (i.e. with same 1st and 2nd field - separated by ";"), I would need to keep the last record...

5. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Hi experts, I need to print the first field first then last two fields should come next and then i need to print rest of the fields. Input : a1,abc,jsd,fhf,fkk,b1,b2 a2,acb,dfg,ghj,b3,c4 a3,djf,wdjg,fkg,dff,ggk,d4,d5 Expected output: a1,b1,b2,abc,jsd,fhf,fkk...

6. Shell Programming and Scripting

Insert field between two fields using awk or sed

Hi All, I am trying to insert two columns in the following text. I tried awk but failed to achieve. Highly appreciate your help DATETIME="28-Sep-2013;20:09:08;" CONTROL="AB" echo "Myfile.txt;11671;7824.90;2822.48" The DATETIME will be inserted at the beginning and CONTROL will...

7. Shell Programming and Scripting

awk Parse And Create Multiple Files Based on Field Value

Hello: I am working parsing a large input file which will be broken down into multiples based on the second field in the file, in this case: STORE. The idea is to create each file with the corresponding store number, for example: Report_$STORENUM_$DATETIMESTAMP , and obtaining the...

8. Shell Programming and Scripting

awk script to parse case with information in two fields of file

The below awk parser works for most data inputs, but I am having trouble with the last one. The problem is in the below rules steps 1 and 2 come from $2 (NC_000013.10:g.20763686_20763687delinsA) and steps 3 and 4 come from $1 (NM_004004.5:c.34_35delGGinsT). Parse Rules: The header is...

9. Shell Programming and Scripting

awk to parse field and include the text of 1 pipe in field 4

I am trying to parse the input in awk to include the |gc= in $4 but am not able to. The below is close: awk so far: awk '{sub(/\|]+]++/, ""); print }' input.txt Input chr1 955543 955763 AGRN-6|pr=2|gc=75 0 + chr1 957571 957852 AGRN-7|pr=3|gc=61.2 0 + chr1 970621 ...

10. UNIX for Beginners Questions & Answers

Awk: group multiple fields from different records

Hi, My input looks like that: A|123|qwer A|456|tyui A|456|wsxe B|789|dfgh Using awk, I am trying to get: A|123;456|qwer;tyui;wsxe B|789|dfgh For records with same $1, group all the $2 in a field (without replicates), and all the $3 in a field (without replicates). What I have tried:...

LEARN ABOUT MOJAVE

group

GROUP(5)						      BSD File Formats Manual							  GROUP(5)

NAME

     group -- format of the group permissions file

DESCRIPTION

     The file </etc/group> consists of newline separated ASCII records, one per group, containing four colon ':' separated fields. These fields
     are as follows:
	   group     Name of the group.
	   passwd    Group's encrypted password.
	   gid	     The group's decimal ID.
	   member    Group members.

     The group field is the group name used for granting file access to users who are members of the group.  The gid field is the number associ-
     ated with the group name.	They should both be unique across the system (and often across a group of systems) since they control file access.
     The passwd field is an optional encrypted password.  This field is rarely used and an asterisk is normally placed in it rather than leaving
     it blank.	The member field contains the names of users granted the privileges of group.  The member names are separated by commas without
     spaces or newlines.  A user is automatically in a group if that group was specified in their /etc/passwd entry and does not need to be added
     to that group in the /etc/group file.

INTERACTION WITH DIRECTORY SERVICES

     Processes generally find group records using one of the getgrent(3) family of functions.  On Mac OS X, these functions interact with the
     DirectoryService(8) daemon, which reads the /etc/group file as well as searching other directory information services to determine groups and
     group membership.

FILES

     /etc/group

SEE ALSO

     passwd(1), setgroups(2), crypt(3), getgrent(3), initgroups(3), passwd(5), DirectoryService(8)

BUGS

     The passwd(1) command does not change the group passwords.

HISTORY

     A group file format appeared in Version 6 AT&T UNIX.

Mac OS X							   July 18, 1995							  Mac OS X