Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with awk command
Top Forums Shell Programming and Scripting Help with awk command Post 302519236 by gaur.deepti on Tuesday 3rd of May 2011 11:31:54 AM
Old 05-03-2011
Help with awk command
Hi ,

I am writing a awk script which will check the values in field 1 and field 2 based on these values the awk has to update field 4.

Source data
Code:
ABC,XYZ,1,2,3,XXXXXXXXXXXXXX,1,2,3
ABC,123,1,2,3,XXXXXXXXXXXXXXX,1,2,3
ABC,DEF,1,2,3,XXXXXXXXXXXXXXX,1,2,3
ABC,123,1,2,3,XXXXXXXXXXXXXXX,1,2,3

target data
Code:
ABC,XYZ,1,2,3,This is a valid record,1,2,3
ABC,123,1,2,3,XXXXXXXXXXXXXXX,1,2,3
ABC,DEF,1,2,3,This is a valid record,1,2,3
ABC,123,1,2,3,XXXXXXXXXXXXXXX,1,2,3

pls tell me how can i compare two times in awk example.

I tried writing the below awk ..but it's wrong and not giving me the required output

Code:
awk '{$1=='ABC" ;$2=="XYZ" } print $6=='This is a valid record'
END

where I am doing wrong in the above script.

Regards,
Deepti
Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!
Last edited by vgersh99; 05-03-2011 at 12:34 PM.. Reason: code tags, please!
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

assign a command line argument and a unix command to awk variables

Hi , I have a piece of code ...wherein I need to assign the following ... 1) A command line argument to a variable e.g origCount=ARGV 2) A unix command to a variable e.g result=`wc -l testFile.txt` in my awk shell script When I do this : print "origCount" origCount --> I get the... (0 Replies)
Discussion started by: sweta_doshi
0 Replies

2. Shell Programming and Scripting

awk/sed Command : Parse parameter file / send the lines to the ksh export command

Sorry for the duplicate thread this one is similar to the one in https://www.unix.com/shell-programming-scripting/88132-awk-sed-script-read-values-parameter-files.html#post302255121 Since there were no responses on the parent thread since it got resolved partially i thought to open the new... (4 Replies)
Discussion started by: rajan_san
4 Replies

3. UNIX for Dummies Questions & Answers

Basic awk question...getting awk to act on $1 of the command itself

I have a script problem that I am not able to solve due my very limited understanding of unix/awk. This is the contents of test.sh awk '{print $1}' From the prompt if I enter: ./test.sh Hello World I would expect to see "Hello" but all I get is a blank line. Only then if I enter "Hello... (2 Replies)
Discussion started by: JasonHamm
2 Replies

4. Shell Programming and Scripting

awk command for simple join command but based on 2 columns

input1 a_a a/a 10 100 a1 a_a 20 200 b1 b_b 30 300 input2 a_a a/a xxx yyy a1 a1 lll ppp b1 b_b kkk ooo output a_a a/a 10 100 xxx yyy (2 Replies)
Discussion started by: ruby_sgp
2 Replies

5. Shell Programming and Scripting

awk command in script gives error while same awk command at prompt runs fine: Why?

Hello all, Here is what my bash script does: sums number columns, saves the tot in new column, outputs if tot >= threshold val: > cat getnon0file.sh #!/bin/bash this="getnon0file.sh" USAGE=$this" InFile="xyz.38" Min="0.05" # awk '{sum=0; for(n=2; n<=NF; n++){sum+=$n};... (4 Replies)
Discussion started by: catalys
4 Replies

6. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Hi, I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files. To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the... (10 Replies)
Discussion started by: anandek
10 Replies

7. Shell Programming and Scripting

Multiple command execution inside awk command during xml parsing

below is the output xml string from some other command and i will be parsing it using awk cat /tmp/alerts.xml <Alert id="10102" name="APP-DS-ds_ha-140018-componentFailure-S" alertDefinitionId="13982" resourceId="11427" ctime="1359453507621" fixed="false" reason="If Event/Log Level(ANY) and... (2 Replies)
Discussion started by: vivek d r
2 Replies

8. Shell Programming and Scripting

Pass awk field to a command line executed within awk

Hi, I am trying to pass awk field to a command line executed within awk (need to convert a timestamp into formatted date). All my attempts failed this far. Here's an example. It works fine with timestamp hard-codded into the command echo "1381653229 something" |awk 'BEGIN{cmd="date -d... (4 Replies)
Discussion started by: tuxer
4 Replies

LEARN ABOUT MOJAVE

datetime::locale::dz_bt

DateTime::Locale::dz_BT(3)				User Contributed Perl Documentation				DateTime::Locale::dz_BT(3)

NAME

       DateTime::Locale::dz_BT

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'dz_BT' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Dzongkha Bhutan.

DATA

       This locale inherits from the DateTime::Locale::dz locale.

       It contains the following data.

   Days
       Wide (format)

	 XXXXXXXXXXXX
	 XXXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX

       Abbreviated (format)

	 XXXX
	 XXXX
	 XXXX
	 XXXX
	 XXXXX
	 XXX
	 XXX

       Narrow (format)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

       Wide (stand-alone)

	 XXXXXXXXXXXX
	 XXXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX

       Abbreviated (stand-alone)

	 XXXX
	 XXXX
	 XXXX
	 XXXX
	 XXXXX
	 XXX
	 XXX

       Narrow (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

   Months
       Wide (format)

	 XXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXXXXX

       Abbreviated (format)

	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX XX
	 XXX XX
	 XXX XX

       Narrow (format)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

       Wide (stand-alone)

	 XXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXXXXX

       Abbreviated (stand-alone)

	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX XX
	 XXX XX
	 XXX XX

       Narrow (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

   Quarters
       Wide (format)

	 XXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXX

       Abbreviated (format)

	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 XXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXX

       Abbreviated (stand-alone)

	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BCE
	 CE

       Abbreviated

	 BCE
	 CE

       Narrow

	 BCE
	 CE

   Date Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXXXXXXXXXXXXXXX XXXX 05
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXXXXXXXXXXXXXXXXXXX XXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXXXXXXXXXXXXXX XXXX 15

       Long

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXXXXXXXXXXXXXXX XXXX 05
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXXXXXXXXXXXXXXXXXXX XXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXXXXXXXXXXXXXX XXXX 15

       Medium

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXX X XXXX 05
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXX XX XXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXX X XXXX 15

       Short

	  2008-02-05T18:30:30 = 2008-02-05
	  1995-12-22T09:05:02 = 1995-12-22
	 -0010-09-15T04:44:23 = -010-09-15

       Default

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXX X XXXX 05
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXX XX XXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXX X XXXX 15

   Time Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

       Long

	  2008-02-05T18:30:30 = XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

       Medium

	  2008-02-05T18:30:30 = XXXXXXX6:30:30 XXXXXX
	  1995-12-22T09:05:02 = XXXXXXX9:05:02 XXXXX
	 -0010-09-15T04:44:23 = XXXXXXX4:44:23 XXXXX

       Short

	  2008-02-05T18:30:30 = XXXXXXX 6 XXXXXX 30 XXXXXX
	  1995-12-22T09:05:02 = XXXXXXX 9 XXXXXX 05 XXXXX
	 -0010-09-15T04:44:23 = XXXXXXX 4 XXXXXX 44 XXXXX

       Default

	  2008-02-05T18:30:30 = XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXXXXXXXXXXXXXXX XXXX 05 XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXXXXXXXXXXXXXXXXXXX XXXX 22 XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXXXXXXXXXXXXXX XXXX 15 XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

       Long

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXXXXXXXXXXXXXXX XXXX 05 XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXXXXXXXXXXXXXXXXXXX XXXX 22 XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXXXXXXXXXXXXXX XXXX 15 XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

       Medium

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXX X XXXX 05 XXXXXXX6:30:30 XXXXXX
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXX XX XXXX 22 XXXXXXX9:05:02 XXXXX
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXX X XXXX 15 XXXXXXX4:44:23 XXXXX

       Short

	  2008-02-05T18:30:30 = 2008-02-05 XXXXXXX 6 XXXXXX 30 XXXXXX
	  1995-12-22T09:05:02 = 1995-12-22 XXXXXXX 9 XXXXXX 05 XXXXX
	 -0010-09-15T04:44:23 = -010-09-15 XXXXXXX 4 XXXXXX 44 XXXXX

       Default

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXX X XXXX 05 XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXX XX XXXX 22 XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXX X XXXX 15 XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 XXXX
	  1995-12-22T09:05:02 = 22 XXXXX
	 -0010-09-15T04:44:23 = 15 XXX

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 XXXXXX
	  1995-12-22T09:05:02 = 9:05 XXXXX
	 -0010-09-15T04:44:23 = 4:44 XXXXX

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 XXXXXX
	  1995-12-22T09:05:02 = 9:05:02 XXXXX
	 -0010-09-15T04:44:23 = 4:44:23 XXXXX

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = XXXX, 2-5
	  1995-12-22T09:05:02 = XXXXX, 12-22
	 -0010-09-15T04:44:23 = XXX, 9-15

       MMM (LLL)

	  2008-02-05T18:30:30 = XXX X
	  1995-12-22T09:05:02 = XXX XX
	 -0010-09-15T04:44:23 = XXX X

       MMMd (MMM d)

	  2008-02-05T18:30:30 = XXX X 5
	  1995-12-22T09:05:02 = XXX XX 22
	 -0010-09-15T04:44:23 = XXX X 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = XXXX XXX X 5
	  1995-12-22T09:05:02 = XXXXX XXX XX 22
	 -0010-09-15T04:44:23 = XXX XXX X 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = XXXXXXXXXXXXXXXX 5
	  1995-12-22T09:05:02 = XXXXXXXXXXXXXXXXXXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXXXXXXXXX 15

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = XXXX XXXXXXXXXXXXXXXX 5
	  1995-12-22T09:05:02 = XXXXX XXXXXXXXXXXXXXXXXXXX 22
	 -0010-09-15T04:44:23 = XXX XXXXXXXXXXXXXXX 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = XXXX, 2008-2-5
	  1995-12-22T09:05:02 = XXXXX, 1995-12-22
	 -0010-09-15T04:44:23 = XXX, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 XXX X
	  1995-12-22T09:05:02 = 1995 XXX XX
	 -0010-09-15T04:44:23 = -10 XXX X

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = XXXX, 2008 XXX X 5
	  1995-12-22T09:05:02 = XXXXX, 1995 XXX XX 22
	 -0010-09-15T04:44:23 = XXX, -10 XXX X 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 XXXXXXXXXXXXXXXX
	  1995-12-22T09:05:02 = 1995 XXXXXXXXXXXXXXXXXXXX
	 -0010-09-15T04:44:23 = -10 XXXXXXXXXXXXXXX

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 XXXXXXXXX
	  1995-12-22T09:05:02 = 1995 XXXXXXXXX
	 -0010-09-15T04:44:23 = -10 XXXXXXXXX

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       XXXXXXXXXXXX

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06						DateTime::Locale::dz_BT(3)
All times are GMT -4. The time now is 06:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy