Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk for loop

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk for loop
# 1  
Old 05-16-2014
awk for loop
Hi All,
i have three files
inputfile
Code:
hello1,my name is unix.com. hello1,I am awesome. Hope you know this,hello2!,wat else hello2!

hello1.txt
Code:
Hi Friends
Hi Folks
Hi Well-Wishers

hello2.txt
Code:
Honey
Sweety
Darling

Expected output
Code:
Hi Friends,my name is unix.com. Hi Friends,I am awesome. Hope you know this,Honey!,wat else Honey!
Hi Folks,my name is unix.com. Hi Folks,I am awesome. Hope you know this,Sweety!,wat else Sweety!
Hi Well-Wishers,my name is unix.com. Hi Well-Wishers,I am awesome. Hope you know this,Darling!,wat else Darling!

requirement is to replace all hello1 by rows of hello1.txt and all hello2 by rows of hello2.txt in inputfile.
output file should have rows as many as in hello1.txt & hello2.txt.
hello1.txt & hello2.txt will always have same number of rows.

i have tried below command
Code:
nawk '{A[++c] = $0} END { for ( i = 1; i <=3; i++ ) { gsub("hello1",A[i],A[c]) gsub("hello2",A[i+3],A[c]); print A[c]}}' hello1.txt hello2.txt inputfile

output
Code:
Hi Friends,my name is unix.com. Hi Friends,I am awesome. Hope you know this,Honey!,wat else Honey!
Hi Friends,my name is unix.com. Hi Friends,I am awesome. Hope you know this,Honey!,wat else Honey!
Hi Friends,my name is unix.com. Hi Friends,I am awesome. Hope you know this,Honey!,wat else Honey!

The loop is taking only first row from hello1.txt.i want loop should go for 2nd & 3rd row from hello1.txt

There must be small ammendment in above command.I want ammendment in above command only.as iwant to learn how for loop works.
# 2  
Old 05-16-2014
This
Code:
gsub("hello1",A[i],A[c])

is changing the value of "A[c]" so the next time through the "hello1" string isn't there anymore.
# 3  
Old 05-16-2014
Here is another awk approach:
Code:
nawk '
        NR == FNR {
                A = $0
                next
        }
        {
                idx = FILENAME
                sub ( /\..*/, X, idx )
                F[idx]++
                R[idx OFS F[idx]] = $0
        }
        END {
                for ( j = 1; j <= F[idx]; j++ )
                {
                        T = A
                        for ( k in F )
                                gsub ( k, R[k OFS j], T )
                        print T
                }
        }
' inputfile hello1.txt hello2.txt

This User Gave Thanks to Yoda For This Post:
jacobs.smith
# 4  
Old 05-19-2014
Thanks Yoda,
In below code
Code:
nawk '{A[++c] = $0} END { for ( i = 1; i <=3; i++ ) { gsub("hello1",A[i],A[c]) gsub("hello2",A[i+3],A[c]); print A[c]}}' hello1.txt hello2.txt inputfile

i am running for loop against 3 values in hello1 then try to replace values in inputfile(for text "hello2,hello2").
if possible can you let me know what is missing in above code?
why it is replacing only 1st value from hello1.txt?if possible can you please send corrected code.
# 5  
Old 05-19-2014
You need a work variable that is restored at each iteration
Code:
nawk '
{A[++c] = $0}
END {
 for ( i = 1; i <=3; i++ ) {
  x=A[c]
  gsub("hello1",A[i],x)
  gsub("hello2",A[i+3],x)
  print x
 }
}' hello1.txt hello2.txt inputfile

These 2 Users Gave Thanks to MadeInGermany For This Post:
jacobs.smith Makarand Dodmis
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk !seen[$]++ in else loop

Hi all, I was searching the net for a solution for my problem... unfortunately nothing so far. I want to sort on more than on column tab delimited file and keep the line if in the column I sort there is no value, but for those who have a value I want them only unique. I have tried the... (5 Replies)
Discussion started by: ksenia
5 Replies

2. UNIX for Beginners Questions & Answers

awk with For loop

Hi My Requirement is to take the sum of each column below is the input file. 1 2 3 4 1 2 3 4 1 2 3 4 Initial i was using below command to achieve my desired result. however this was adding the row and not column. i am not able understand why this is happening awk... (1 Reply)
Discussion started by: scriptor
1 Replies

3. Shell Programming and Scripting

awk programming -Passing variable to awk for loop

Hi All, I am new to AWK programming. I have the following for loop in my awk program. cat printhtml.awk: BEGIN -------- <some code here> END{ ----------<some code here> for(N=0; N<H; N++) { for(M=5; M<D; M++) print "\t" D ""; } ----- } ... (2 Replies)
Discussion started by: ctrld
2 Replies

4. Shell Programming and Scripting

awk loop using array:wish to store array values from loop for use outside loop

Here's my code: awk -F '' 'NR==FNR { if (/time/ && $5>10) A=$2" "$3":"$4":"($5-01) else if (/time/ && $5<01) A=$2" "$3":"$4-01":"(59-$5) else if (/time/ && $5<=10) A=$2" "$3":"$4":0"($5-01) else if (/close/) { B=0 n1=n2; ... (2 Replies)
Discussion started by: klane
2 Replies

5. Shell Programming and Scripting

awk loop and using shell in awk

Hi, everyone! I have a file, when I print its $1 out it show several strings like this: AABBCC AEFJKLFG FALEF FAIWEHF What I want to do is that, after output of each record, search the string in all files in the same folder, print out the record and file name. This is what I want... (4 Replies)
Discussion started by: xshang
4 Replies

6. Shell Programming and Scripting

awk - loop from a to z

Hello, I was wondering if it is possible to do a loop on letters rather than numbers with awk (gawk). Basically I used to do: echo "nothing" | gawk '{for(i=1;i<11;i++)print i}' But I would like to do something like that (which obviously does not work): echo "nothing" | gawk '{for(i in... (6 Replies)
Discussion started by: jolecanard
6 Replies

7. Shell Programming and Scripting

Comparison and editing of files using awk.(And also a possible bug in awk for loop?)

I have two files which I would like to compare and then manipulate in a way. File1: pictures.txt 1.1 1.3 dance.txt 1.2 1.4 treehouse.txt 1.3 1.5 File2: pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244 dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2... (1 Reply)
Discussion started by: linuxkid
1 Replies

8. Shell Programming and Scripting

awk for-loop and NR

Hey, I know this is a stupid question, but it doesn't work. I have a file with 10 lines and I want to pipe the content to awk and then print line 1 til 2 into another file and then line 3-4 ... So my script looks like that, but doesn't work: cat grid_ill.pts | awk '{ for (NR=1;NR<3;NR++)... (8 Replies)
Discussion started by: ergy1983
8 Replies

9. UNIX for Dummies Questions & Answers

for loop in awk?

I am new to unix and have pieced together two scripts that work independently. The first checks all the filesystems and reports which are running low on space. df -m | awk 'int($4) > 75 { print $1 " has only " $3 "mb free from a total of " $2 ", this filesystem is " $4 " full! \n" }... (1 Reply)
Discussion started by: Bdawk
1 Replies

10. Shell Programming and Scripting

Using AWK in a for loop

Hello, I am trying to use AWK to print only the first field of numerous text files, and then overwrite these files. They are of the format 1*2,3,4,5. I have tried the following code (using tcsh): foreach f (file1 file2 file3) cat $f | awk -F'*' '{print $1}' > $f end However, I get very... (4 Replies)
Discussion started by: Jahn
4 Replies
Login or Register to Ask a Question