Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: OR operator syntax question in AWK script
Top Forums Shell Programming and Scripting OR operator syntax question in AWK script Post 302416063 by cgkmal on Saturday 24th of April 2010 05:11:17 PM
Old 04-24-2010
Hey penchal,

Many thanks, the magic character "\" was missing for me, great to know now.

One more question regarding this:

Independently and without use what I have in other columns, how can
I replace a field value in specific line using AWK?

Inputfile (In 3rd column all lines contain the same pattern)
Code:
January|Month No. 1|Normal month
February|Month No. 2|Normal month
March|Month No. 3|Normal month
April|Month No. 4|Normal month
May|Month No. 5|Normal month
June|Month No. 6|Normal month
July|Month No. 7|Normal month
August|Month No. 8|Normal month
September|Month No. 9|Normal month
October|Month No. 10|Normal month
November|Month No. 11|Normal month
December|Month No. 12|Normal month

I would like to replace only the first and last line in column 3 as follow:
Code:
January|Month No. 1|First month
February|Month No. 2|Normal month
March|Month No. 3|Normal month
April|Month No. 4|Normal month
May|Month No. 5|Normal month
June|Month No. 6|Normal month
July|Month No. 7|Normal month
August|Month No. 8|Normal month
September|Month No. 9|Normal month
October|Month No. 10|Normal month
November|Month No. 11|Normal month
December|Month No. 12|Last month

I´m not sure how to use the "if" and "and" conditions together. I´m trying for the first part with this code, but the result is not what I need, because this script replaces all ocurrences:
Code:
awk 'BEGIN {OFS=FS="|"; IGNORECASE=1} {if($3 && NR=1) sub(/Normal month/,"First month",$3); print}' inputfile

January|Month No. 1|First month
February|Month No. 2|First month
March|Month No. 3|First month
April|Month No. 4|First month
May|Month No. 5|First month
June|Month No. 6|First month
July|Month No. 7|First month
August|Month No. 8|First month
September|Month No. 9|First month
October|Month No. 10|First month
November|Month No. 11|First month
December|Month No. 12|First month

Then, how can I replace values for first and last lines within same AWK script?

Maybe somebody could help me with this.

Thanks in advance.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk syntax question

Hi there could someone explain what is happening in the following function/statement for me, im just a little confused code = 'BEGIN{FS=","} { printf ("%-11s,%s%s%s,%07.2f,%14s,%-3s\n",$1,substr($2,9,2),substr($2,6,2),substr($ 2,3,2),$9,$10,$12) } this function is called later in the... (2 Replies)
Discussion started by: hcclnoodles
2 Replies

2. Shell Programming and Scripting

yet another awk field syntax question

I am trying to print the remaing fields and field numbers beginning with a field 'xyz' #cat abc test1:test2:xyz:test3:test4:test5 #cat def test1:test2:test3:xyz:test4:test5 desired output is to be able to print NF and any trailing fields separated by':' test3 3 or test4 3 or test5... (4 Replies)
Discussion started by: prkfriryce
4 Replies

3. UNIX for Dummies Questions & Answers

AWK syntax question

Hi, Have to check file names in some given directory. SO, What is the right syntax here: *$3*=="'$object_list'" - just wanted to check if $3 is in the object_list. And also, Do I need so many quotes around? (5 Replies)
Discussion started by: Leo_NN
5 Replies

4. Shell Programming and Scripting

syntax error: `-a' unexpected operator/operand in IF

When i tyr this, it gives me a syntax error...i tried removing quotes,removing spaces,replacing -eq with '='.. Can somebody suggest that is the problem? if ]; then (4 Replies)
Discussion started by: dba.admin2008
4 Replies

5. Shell Programming and Scripting

syntax error in shell test: unknown operator

Hi All, can some one figure out the syntax issue here. How to overcome this? #!/bin/sh $ HFR_MAIL=NO $ PRP_MAIL=NO $ MC_MAIL=NO $ if && && ]; then > echo "NO " > else > echo "YES" > fi test: unknown operator NO $ if && && ]; then > echo "NO" > else > echo "YES" >... (4 Replies)
Discussion started by: shellscripter
4 Replies

6. Shell Programming and Scripting

zsh ternary operator syntax help

Hi, Can someone give me an example of how to use zsh's ternary operator? I tried: # a=1 # c=( a ? "true" : "false" ) and got: zsh: no matches found: ? I'm running zsh 4.2 on RHEL AS 4. Thanks! Paul (1 Reply)
Discussion started by: paul99
1 Replies

7. Shell Programming and Scripting

awk syntax question

Hi I use awk command to delete the first blanc line of a file: awk '/^$/ && !f{f=1;next}1' infile > outfile can somebody please explain me what the last "1'" in !f{f=1;next}1' stands for... Thansk a lot -A (3 Replies)
Discussion started by: aoussenko
3 Replies

8. UNIX for Dummies Questions & Answers

syntax error: invalid arithmetic operator

hi, i have a bash script that i want to receive a a string from another bash file. But because the string has a dot in the middle it gives me an error. The error is in this line: let valor=$1 and the value passed is rules.txt the error is: let: valor=rules.txt: syntax error: invalid... (2 Replies)
Discussion started by: limadario
2 Replies

9. Shell Programming and Scripting

syntax question in regards to nested awk statements

Hello all, I am writing up an input file and I was hoping I could get some guidance as to how to best consolidate these 2 awk statements for 1 while loop. Here's my input file # cat databases.lst #NOTE: These entries are delimited by tabs "\t" #oracleSID name/pass # db11 ... (2 Replies)
Discussion started by: Keepcase
2 Replies

10. Shell Programming and Scripting

Getting syntax error with awk ternary operator

split($7,a," "); date = a; time = a split(date,d,"/"); month = sprintf("%02d",d); day = sprintf("%02d",d); year = 2000 + d % 100 split(time,t,":"); hour=t; min=t hour >= 12? { hour=hour-12; amPm=" PM" } : amPM=" AM" hour == 0? hour=12 time=sprintf("%02d",hour)":"sprintf("%02d",min)amPm ... (4 Replies)
Discussion started by: Michael Stora
4 Replies

LEARN ABOUT OPENSOLARIS

diffmk

diffmk(1)							   User Commands							 diffmk(1)

NAME

       diffmk - mark differences between versions of a troff input file

SYNOPSIS

       diffmk oldfile newfile markedfile

DESCRIPTION

       diffmk  compares  two versions of a file and creates a third version that includes "change mark" (.mc) commands for nroff(1) and  troff(1).
       oldfile and newfile are the old and new versions of the file. diffmk generates markedfile, which,  contains  the  text  from  newfile  with
       troff(1) "change mark" requests (.mc) inserted where  newfile differs from  oldfile. When markedfile is formatted, changed or inserted text
       is shown by  | at the right margin of each line. The position of deleted text is shown by a single *.

USAGE

       See largefile(5) for the description of the behavior of diffmk when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).

EXAMPLES

       Example 1 An example of the diffmk command.

       diffmk can also be used in conjunction with the proper  troff requests to produce program listings with marked changes.	In  the  following
       command line:

	 example% diffmk old.c new.c marked.c ; nroff reqs marked.c | pr

       the file reqs contains the following troff requests:

	 .pl 1
	 .ll 77
	 .nf
	 .eo
	 .nh

       which eliminate page breaks, adjust the line length, set no-fill mode, ignore escape characters, and turn off hyphenation, respectively.

       If the characters  | and * are inappropriate, you might run  markedfile through	sed(1) to globally change them.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWdoc			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       diff(1), nroff(1), sed(1), troff(1), attributes(5), largefile(5)

BUGS

       Aesthetic  considerations  may  dictate	manual	adjustment of some output. File differences involving only formatting requests may produce
       undesirable output, that is, replacing .sp by .sp 2 will produce a "change mark" on the preceding or following line of output.

SunOS 5.11							    14 Sep 1992 							 diffmk(1)
All times are GMT -4. The time now is 07:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy