Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk two fields in one array

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk two fields in one array
# 1  
Old 01-31-2012
awk two fields in one array
I want to compare these files while putting $1 and $2 into an array and getting rid of the punctuation. What am i doing wrong?

File1.txt
HTML Code:
Apple # 223
Peach # 84;
Banana # 1605.
Banana # 1605;
Orange # 6;
Peach # 84
Peach # 84;
Apple # 229;
Banana # 1605.
Peach # 84
Apple, # 229;
Banana, # 1605.
Orange # 6b.
File2.txt
HTML Code:
Store 3: Apple # 223
Store 2: Apple # 229
Store 4: Apple # 229
Stroe 1: Apple # 200
Store 3: Banana # 1605
Store 1: Banana # 1605
Store 3: Banana # 1605
Store 5: Banana # 1605
Store 6: Banana # 1301
Store 1: Banana # 1301
Store 1: Peach # 84
Store 5: Peach #600
Store 3: Peach # 84
Store 2: Peach # 84
Store 4: Peach # 84
Store 1: Orange # 6
Store 3: Orange # 5
Store 2: Orange # 6b
Output.txt
HTML Code:
Store 3: Apple # 223
Store 2: Apple # 229
Store 4: Apple # 229
Store 3: Banana # 1605
Store 1: Banana # 1605
Store 3: Banana # 1605
Store 5: Banana # 1605
Store 1: Peach # 84
Store 3: Peach # 84
Store 2: Peach # 84
Store 4: Peach # 84
Store 1: Orange # 6
Store 2: Orange # 6b
Code:
awk -F'[:=#]' 'NR==FNR{a[$1 , $2];next} {if($2 in a[1] && $3 in a[2]) print $0}'

Last edited by sdf; 01-31-2012 at 06:54 PM.. Reason: added output.txt
# 2  
Old 01-31-2012
What is the desired output for those two files?
# 3  
Old 01-31-2012
What output do you want?
# 4  
Old 01-31-2012
Can anybody help this isn't working either.

Code:
awk -F"[:#]" 'NR==FNR{a=$0} $2 ~ a[1] && $3 ~ a[2] { print $0}'

Last edited by sdf; 02-01-2012 at 09:22 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Psql output into array and read 2 fields into different variables

Hello Just edited the entry to make it easier to understand what i want How can i achieve this: GOAL: read 2 field from a table with PSQL result of this PSQL command is this INSTALLEDLANG=$(su - postgres -c "psql -A -t -q -c -d ${DBNAME} -t -c 'SELECT code, iso_code from res_lang'") ... (0 Replies)
Discussion started by: winston6071
0 Replies

2. 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 Replies)
Discussion started by: newstart
9 Replies

3. 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 Replies)
Discussion started by: sljnk
7 Replies

4. 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 Replies)
Discussion started by: 100bees
6 Replies

5. Shell Programming and Scripting

Join fields comparing 4 fields using awk

Hi All, I am looking for an awk script to do the following Join the fields together only if the first 4 fields are same. Can it be done with join function in awk?? a,b,c,d,8,,, a,b,c,d,,7,, a,b,c,d,,,9, a,b,p,e,8,,, a.b,p,e,,9,, a,b,p,z,,,,9 a,b,p,z,,8,, desired output: ... (1 Reply)
Discussion started by: aksijain
1 Replies

6. UNIX for Dummies Questions & Answers

Fill fields with awk from an array?

Hi experts, I have been trying for a while to accomplish the following task using awk, and I just don't seem find find a way. I am not particular about using awk, it just seemed like the logical choice at first. I have a file that contains 5 fields that are delimited by a space character.... (1 Reply)
Discussion started by: GermanicGalore
1 Replies

7. Shell Programming and Scripting

how to spilit a row into fields and store the field content to the array

consider this is a line A#B#C#D#E#F#G#H note the delimeter is # i want to cut or spilt in to fields using the delimeter # and to store in an array. like this array=A array=B array=C array=D array=E and the array content should be displayed. echo "${array}" echo "${array}"... (5 Replies)
Discussion started by: barani75
5 Replies

8. Shell Programming and Scripting

one solution if want fields in a file into each array

Hi Everyone, This is just my method to if want fields in a file into each array. # cat /tmp/3.txt 00:00:01 1 00:00:02 2 00:00:03 33 # cat text.pl #!/usr/bin/perl @field1 = `cat '/tmp/3.txt' | cut -f1 -d'\t'`; print $field1; # ./text.pl 00:00:01 # As we can... (4 Replies)
Discussion started by: jimmy_y
4 Replies

9. 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,... (4 Replies)
Discussion started by: axo959
4 Replies

10. Shell Programming and Scripting

awk reading many fields to array

I want to read $3,$4,$5,$6,$7 of fileA in array and when fileb $1 = fileA $4 the i want to print array and few fields from fileB. This should work but has some syntax error. nawk -F, 'FNR==NR{a=;next} a{print a}' fileB fileA Appreciate if someone can correct this. (2 Replies)
Discussion started by: pinnacle
2 Replies
Login or Register to Ask a Question