Awk: group multiple fields from different records Post: 303019792

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

AWK ??-print for fields within records in a file

Hello all, Would appreciate if someone can help me out on the following requirement. INPUT FILE: -------------------------- TPS REPORT abc def ghi jkl mon pqr stu vrs lll END OF TPS REPORT TPS REPORT field1 field2 field3 field4 field5 field6

2. Infrastructure Monitoring

Processing records as group - awk

I have a file has following records policy glb id 1233 name Permit ping from "One" to "Second" "Address1" "Any" "ICMP-ANY" permit policy id 999251 service "snmp-udp" exit policy glb id 1234 name Permit telnet from "One" to "Second" "Address2" "Any" "TCP-ANY" permit policy id 1234...

3. Shell Programming and Scripting

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

When parsing multiple fields in a file using AWK, how do you group by one of the fields and parse by delimiters? to clarify If a file had tom | 223-2222-4444 , randofield ivan | 123-2422-4444 , random filed ... | and , are the delimiters ... How would you group by the social security...

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

awk gsub multiple fields

Hi, I am trying to execute this line awk -F ";" -v OFS=";" '{gsub(/\./,",",$6); print}' FILE but for multiple fields $6 $7 $8 Do you have a suggstion? Tried: awk -F ";" -v OFS="";"" "function GSUB( F ) {gsub(/\./,\",\",$F); print} { GSUB( 6 ); GSUB( 7 ); GSUB( 8 ) } 1"...

6. Shell Programming and Scripting

awk multiple fields separators

Can you please help me with this .... Input File share "FTPTransfer" "/v31_fs01/root/FTP-Transfer" umask=022 maxusr=4294967295 netbios=NJ09FIL530 share "Test" "/v31_fs01/root/Test" umask=022 maxusr=4294967295 netbios=NJ09FIL530 share "ENR California" "/v31_fs01/root/ENR California"...

7. UNIX for Dummies Questions & Answers

Make all records with the same number of fields (awk)

Hi, input: AA|BB|CC DD|EE FF what I am trying to get: AA|BB|CC DD|EE| FF|| I tried to create first an UDF for printing repeats, but I think I have an issue with my END section or my array: function repeat(str, n, rep, i) { for(i=1 ;i<n;i++) rep=rep str return rep } ...

8. Shell Programming and Scripting

Shell Script to Group by Based on Multiple Fields in a file

Hi, I want to know if there is any simple approach to SUM a field based on group by of different fields for e.g. file1.txt contains below data 20160622|XXX1||50.00||50.00|MONEY|Plan1| 20160622|XXX1||100.00||100.00|MONEY|Plan1| 20160623|XXX1||25.00||25.00|MONEY|Plan1|...

9. Shell Programming and Scripting

Print multiple fields with awk

so its common knowledge one can print multiple fields with simple commands like this: echo 12 44 45 552 24 | awk '{print $1,$4,$3}' but suppose i want to avoid specifying the "$" symbol. is that possible? can something like this be done: echo 12 44 45 552 24 | awk '{print $(1,4,3)}' ...

10. UNIX for Beginners Questions & Answers

awk for matching fields between files with repeated records

Hello all, I am having trouble with what should be an easy task, but seem to be missing something fundamental. I have two files, with File 1 consisting of a single field of many thousands of records. I also have File 2 with two fields and many thousands of records. My goal is that when $1 of...

LEARN ABOUT DEBIAN

viewperl

VIEWPERL(1)							   User Commands						       VIEWPERL(1)

NAME

       viewperl - quickly view syntax highlighted Perl code

SYNOPSIS

       viewperl [OPTION]... FILE...

DESCRIPTION

       View a Perl source code file, syntax highlighted.

       -c, --code=CODE
	      view CODE, syntax highlighted

       -l, --lines
	      display line numbers

       -L, --no-lines
	      supress display of line numbers (default)

       -m, --module=FILE
	      consider FILE the name of a module, not a file name

       -n, --name
	      display the name of each file (default)

       -N, --no-name
	      supress display of file names (implied by --no-reset)

       -p, --pod
	      display inline POD documentation (default)

       -P, --no-pod
	      hide POD documentation (line numbers still increment)

       -r, --reset
	      reset formatting and line numbers each file (default)

       -R, --no-reset
	      supress resetting of formatting and line numbers

       -s, --shift=WIDTH
	      set tab width (default is 4)

       -t, --tabs
	      translate tabs into spaces (default)

       -T, --no-tabs
	      supress translating of tabs into spaces

       --help display this help and exit

       Note that module names should be given as they would appear after a Perl `use' or `require' statement.  `Getopt::Long', for example.

       Each string given using -c is considered a different file, so line number and formatting resets will apply.

       View a Perl source code file, syntax highlighted.

       -c, --code=CODE
	      view CODE, syntax highlighted

       -l, --lines
	      display line numbers

       -L, --no-lines
	      supress display of line numbers (default)

       -m, --module=FILE
	      consider FILE the name of a module, not a file name

       -n, --name
	      display the name of each file (default)

       -N, --no-name
	      supress display of file names (implied by --no-reset)

       -p, --pod
	      display inline POD documentation (default)

       -P, --no-pod
	      hide POD documentation (line numbers still increment)

       -r, --reset
	      reset formatting and line numbers each file (default)

       -R, --no-reset
	      supress resetting of formatting and line numbers

       -s, --shift=WIDTH
	      set tab width (default is 4)

       -t, --tabs
	      translate tabs into spaces (default)

       -T, --no-tabs
	      supress translating of tabs into spaces

       --help display this help and exit

       Note that module names should be given as they would appear after a Perl `use' or `require' statement.  `Getopt::Long', for example.

       Each string given using -c is considered a different file, so line number and formatting resets will apply.

viewperl							    August 2007 						       VIEWPERL(1)