awk with fields select? Post: 302601836

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

printing select fields in awk

Hi, I want to print certain fields from my data file depending on certain conditions. Somebody pls let me know how to send it to awk. The command below is the one which I want to use in a shell script and this prints fine cat ./datafile.dat | grep -i $SEARCH_STR | awk -F: '{ print $1 $2 $3...

2. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want. The vendor wants me to submit three fields to them. Field 1 is the studentid field,...

3. UNIX for Dummies Questions & Answers

Select Distinct on multiple fields

How do I create a script that provides a count of distinct values of a particular field in a file utilizing commonly available UNIX commands (sh or awk)? Field1|Field2|Field3|Field4 AAA|BBB|CCC|DDD 111|222|333|777 AAA|EEE|ZZZ|EEE 111|555|333|444 AAA|EEE|CCC|DDD 111|222|555|444 For...

4. Shell Programming and Scripting

select lines with certain values on certain fields with awk

I need a awk command to select from a log-file only the lines that have on the 2nd field (considering "|" separator) one of the values 10.216.22.XX or 10.216.22.YY or 10.216.22.ZZ and on the 4th field only values that contain strictly digits. I want the command to work parsing the file only once (I...

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

awk - compare 1st 15 fields of record with 20 fields

I'm trying to compare 2 files for differences in a selct number of fields. When differnces are found it will write the whole record of the second file including appending '|C' out to a delta file. Each record will have 20 fields, but only want to do comparison of 1st 15 fields. The 1st field of...

7. Shell Programming and Scripting

Select records and fields

Hi All I would like to modify a file like this: >antax gioq21 tris notes abcdefghij klmnopqrs >betax gion32 ter notes2 tuvzabcdef ahgskslsooin this: >tris abcdefghij klmnopqrs >ter tuvzabcdef ahgskslsoo So, I would like to remove the first two fields(and output field 3) in record...

8. Shell Programming and Scripting

awk sort based on difference of fields and print all fields

Hi I have a file as below <field1> <field2> <field3> ... <field_num1> <field_num2> Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields. I tried this and it doesn't sort on the difference field .. Appreciate your help. cat...

9. Shell Programming and Scripting

awk to print match or non-match and select fields/patterns for non-matches

In the awk below I am trying to output those lines that Match between file1 and file2, those Missing in file1, and those missing in file2. Using each $1,$2,$4,$5 value as a key to match on, that is if those 4 fields are found in both files the match, but if those 4 fields are not found then missing...

10. Shell Programming and Scripting

awk move select fields to match file prefix in two directories

In the awk below I am trying to use the file1 as a match to file2. In file2 the contents of $5,&6,and $7 (always tab-delimited) and are copied to the output under the header Quality metrics. The below executes but the output is empty. I have added comments to help and show my thinking. Thank you...

LEARN ABOUT DEBIAN

mojo::date

Mojo::Date(3pm) 					User Contributed Perl Documentation					   Mojo::Date(3pm)

NAME

       Mojo::Date - HTTP 1.1 date container

SYNOPSIS

	 use Mojo::Date;

	 my $date = Mojo::Date->new(784111777);
	 my $http_date = $date->to_string;
	 $date->parse('Sun, 06 Nov 1994 08:49:37 GMT');
	 my $epoch = $date->epoch;

DESCRIPTION

       Mojo::Date implements HTTP 1.1 date and time functions according to RFC 2616.

	 Sun, 06 Nov 1994 08:49:37 GMT	; RFC 822, updated by RFC 1123
	 Sunday, 06-Nov-94 08:49:37 GMT ; RFC 850, obsoleted by RFC 1036
	 Sun Nov  6 08:49:37 1994	; ANSI C's asctime() format

ATTRIBUTES

       Mojo::Date implements the following attributes.

   "epoch"
	 my $epoch = $date->epoch;
	 $date	   = $date->epoch(784111777);

       Epoch seconds.

METHODS

       Mojo::Date inherits all methods from Mojo::Base and implements the following new ones.

   "new"
	 my $date = Mojo::Date->new;
	 my $date = Mojo::Date->new($string);

       Construct a new Mojo::Date object.

   "parse"
	 $date = $date->parse('Sun Nov	6 08:49:37 1994');

       Parse date in one of the following formats.

	 - Epoch format(784111777)
	 - RFC 822/1123 (Sun, 06 Nov 1994 08:49:37 GMT)
	 - RFC 850/1036 (Sunday, 06-Nov-94 08:49:37 GMT)
	 - ANSI C asctime() (Sun Nov  6 08:49:37 1994)

   "to_string"
	 my $string = $date->to_string;

       Render date suitable for HTTP 1.1 messages.

SEE ALSO

       Mojolicious, Mojolicious::Guides, <http://mojolicio.us>.

perl v5.14.2							    2012-09-05							   Mojo::Date(3pm)