|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
help in awk arrays!
Post 302558614 by ctsgnb on Saturday 24th of September 2011 12:28:08 PM
09-24-2011
Code:
$ cat f1 Id1 pp1 0t4 pp8 xy2 Id43 009y black Id6 red xy2 Id12 new pp1 black
Code:
$ cat f2 Id pp1 black new pp8
Code:
$ nawk 'NR==FNR{for(i=0;++i<=NF;){A[$i]=$i};next}{for(k=0;++k<=NF;){for(j in A){if($k~A[j]) {x=((length(x))?x" ":x) $k;break}}};print x;x=y}' f2 f1
Id1 pp1 pp8
Id43 black
Id6
Id12 new pp1 black| nawk 'NR==FNR{ | when scanning the first file |
for(i=0;++i<=NF { | loop over all field of lines |
| A[$i]}; | store those field in an associative array |
| next} | process next line |
| {for(k=0;++k<=NF{ | Loop over all fields of file to analyse |
| for(j in A){ | Loop over the previously built associativ array |
| if($k~j) { | if field match a pattern of associativ array |
| x=((length(x))?x" ":x) $k | The field is retain to be prompted |
| break | at first match, go stop looping over the array |
| } | |
| } | end of field checking over the array |
| } | when all fields have been analyzed |
| print x | print the concatenation of thos who have been retained |
| x=y | clear x to make it ready for scanning next line |
| }' f2 f1 | note that the file contaning the pattern is passed as first argument |
could be shorten a little by removing what is in red in previous code.
Code:
nawk 'NR==FNR{for(i=0;++i<=NF;){A[$i]};next}{for(k=0;++k<=NF;){for(j in A){if($k~j) {x=((length(x))?x" ":x) $k;break}}};print x;x=y}' f2 f1Last edited by ctsgnb; 09-24-2011 at 07:39 PM..
This User Gave Thanks to ctsgnb For This Post:
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi All,
I have been working on awk and arrays. I have this small script:
cat maillog*|awk -F: '$2=="SMTP-Accept" && $5~/string/ {lastdate=substr($1,1,8); internaluser=$5; v++} END {for (j in v) {print lastdate, v, j}'| sort>> mail.list
This gives me the number of mails users are getting. ... (1 Reply)
Discussion started by: nitin
1 Replies
2. Shell Programming and Scripting
Been struggling with a problem, I have been trying to do this in awk, but am unable to figure this out, I think arrays have to be used, but unsure how to accomplish this.
I have a input file that looks like this:
141;ny;y;g
789;ct;e;e
23;ny;n;u
45;nj;e;u
216;ny;y;u
7;ny;e;e
1456;ny;e;g... (3 Replies)
Discussion started by: craigsky
3 Replies
3. Shell Programming and Scripting
Guys,
OK so i have been trying figure this all all day, i guess its a pretty easy way to do it.
Right, so i have to column of data which i have gotten from one huge piece of data. What i would like to do is to put both of these into one array using awk. Is this possible??
If so could... (1 Reply)
Discussion started by: imonthejazz
1 Replies
4. Shell Programming and Scripting
now its owkring - thanks fo rthe help all . (7 Replies)
Discussion started by: fusionX
7 Replies
5. Shell Programming and Scripting
Hi, I've written the following code to manipulate the first 40 lines of a data file into my desired order:
#!/bin/awk -f
{ if (NR<=(4)){
a=a$0" "}
else { if ((NR >= (5)) && (NR <= (13))) {
b=b$0" " }
else {if ((NR >= (14)) && (NR <= (25))){
c=c$0" "}
... (5 Replies)
Discussion started by: catwoman
5 Replies
6. Shell Programming and Scripting
Hi,
I have spent the afternoon trawling Google, Unix.com and Unix in a Nutshell for information on how awk arrays work, and I'm not really getting too far.
I ahve a batch of code that I am pretty sure can be better managed using awk, but I'm not sure how to use awk arrays to do what I'm... (1 Reply)
Discussion started by: littleIdiot
1 Replies
7. Shell Programming and Scripting
Hi,
I have the following data in a file for example:
Name="Fred","Bob","Peterson","Susan","Weseley"
Age="24","30","28","23","45"
Study="English","Engineering","Physics","Maths","Psychology"
Code="0","0","1","1","0"
Name="Fred2","Bob2","Peterson2","Susan2","Weseley2"... (14 Replies)
Discussion started by: james2009
14 Replies
8. UNIX for Dummies Questions & Answers
Hi
Can someone please explain the logic of awk arrays. I have been doing some reading but I dont understand this:
#!/usr/bin/gawk -f
{
arr++;
}
end
{
for(i in arr)
{
print arr,i
}
}
As I understand arr refs the arrays index, so while $2 is a string that cant... (2 Replies)
Discussion started by: chronics
2 Replies
9. Shell Programming and Scripting
I'm a little stuck and would be grateful of some advice!
I have three files, two of which contain reference data that I want to add to a line of output in the third file. I can't seem to get awk to print array contents as I would expect.
The input files are:
# Input file
AAA,OAA,0313... (2 Replies)
Discussion started by: maccas17
2 Replies
10. Shell Programming and Scripting
So I'm back once again beating my head off a wall trying to figure out how to get this to work.
My end goal is to take input such as what's below, which will be capture in real time with a tail -f from a file or piped output from another command:
... (5 Replies)
Discussion started by: ShadowBlade72
5 Replies