Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Print whole line if variables matches

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Print whole line if variables matches
# 1  
Old 06-17-2016
Print whole line if variables matches
Der colleagues,

4 days I am trying to solve my issue and no success..
Maybe you can give me a clue how to achieve what I need..

So I have two files.

file1 example:
Code:
1_column1.1   1_column2.1   aaa   1_column4.1
1_column1.2   1_column2.2   ttt   1_column4.2
1_column1.3   1_column2.3   ddd  1_column4.3
1_column1.3   1_column2.3   ppp 1_column4.3

file2 example:
Code:
aaa   2_column2.1
bbb   2_column2.2
ccc   2_column2.3
ddd   2_column2.4

So what I need is to print whole line of file1 in case if values from 1st column from file2 matches with values from 3rd column of file1.
So, I want to see output like:
Code:
1_column1.1   1_column2.1   aaa   1_column4.1
1_column1.3   1_column2.3   ddd  1_column4.3

Any help highly appreaciated.
# 2  
Old 06-17-2016
Hello nypreH,

Could you please try following and let me know if this helps.
Code:
awk 'FNR==NR{A[$1];next} ($3 in A)'  Input_file2   Input_file1

Output will be as follows.
Code:
1_column1.1   1_column2.1   aaa   1_column4.1
1_column1.3   1_column2.3   ddd  1_column4.3

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
nypreH
# 3  
Old 06-17-2016
Hello Ravinder,

Yes, thats works like a charm!

Thanks for extremely fast answer.
Smilie

---------- Post updated at 04:19 PM ---------- Previous update was at 04:12 PM ----------

Maybe you can suggest how to adapt your code in case I have random number of spaces?

real file1 looks like:
Code:
[AMR FR]_[72]_Capacity 140 NBSC01  AMR_FR
[STIRC]_[393]_Capacity 850 NBSC01  STIRC
[DTM]_[63]_Capacity 1750 NBSC01  DTM
[AMR PPC]_[578]_Capacity 1827 NBSC01  AMR_PPC
[PPC 2]_[606]_Capacity 1827 NBSC01  PPC_2

and file2 looks simply like:

Code:
1234 4
7 16
4 1321
2 1321
14 389
1 1780
13 38
73 584
1750 0
591 0
850 0

So in this case I can't use space as delimiter since there can be different number of spaces in file1 and I need to compare with the bold marked values.
# 4  
Old 06-17-2016
Hello nypreH,

Could you please try following and let me know if this helps you.
Code:
awk 'FNR==NR{split($2, A," ");B[A[1]]=$0;next} ($1 in B){print B[$1]}' FS="Capacity " Input_file1 FS=" " Input_file2

Considering here like you Input_file1 will have keyword Capacity and you want to compare values from the first field of Input_file2.

Thanks,
R. Singh
# 5  
Old 06-17-2016
I ran this command and got nothig in output.
I also changed spaces which separates each column with ^ and tried previous suggested command, but also got nothing:

Code:
awk -F"^" 'NR==FNR{c[$1$2]++;next};c[$1$2] > 0' /tmp/featureCodesAndCapacity /tmp/featureCode1stPart

file1
Code:
[105km Extended Cell for CS]_[1219]_Capacity^754^NBSC01 ^105km_Extended_Cell_for_CS
[105km Extended Cell for CS]_[1219]_Capacity^754 ^NBSC01 ^105km_Extended_Cell_for_CS
[AIS FE BTS]_[587]_Capacity^2700^NBSC01 ^AIS_FE_BTS
[AIS FE BTS]_[587]_Capacity^2700 ^NBSC01 ^AIS_FE_BTS
[Lb Interface basic]_[16]_Capacity^1^NBSC01 ^Lb_Interface_basic
[Lb Interface basic]_[16]_Capacity^1 ^NBSC01 ^Lb_Interface_basic
[Lb AGPS]_[19]_Capacity^1^NBSC01 ^Lb_AGPS
[Lb AGPS]_[19]_Capacity^1 ^NBSC01 ^Lb_AGPS
[Lb UTDOA]_[20]_Capacity^1^NBSC01 ^Lb_UTDOA
[Lb UTDOA]_[20]_Capacity^1 ^NBSC01 ^Lb_UTDOA
[L3 functionality for ESB switch]_[1234]_Capacity^6^NBSC01 ^L3_functionality_for_ESB_switch

file2
Code:
1234^4
7^16
4^1321
2^1321
14^389
1^1780
13^38
73^584
393^0
591^0
834^0
673^0
909^30
1015^0
1262^1807
1273^0
1219^0
1379^1196
3730^85
1826^3
16^0
19^0
20^0

# 6  
Old 06-17-2016
Quote:
Originally Posted by nypreH
I ran this command and got nothig in output.
I also changed spaces which separates each column with ^ and tried previous suggested command, but also got nothing:

Code:
awk -F"^" 'NR==FNR{c[$1$2]++;next};c[$1$2] > 0' /tmp/featureCodesAndCapacity /tmp/featureCode1stPart

file1
Code:
[105km Extended Cell for CS]_[1219]_Capacity^754^NBSC01 ^105km_Extended_Cell_for_CS
[105km Extended Cell for CS]_[1219]_Capacity^754 ^NBSC01 ^105km_Extended_Cell_for_CS
[AIS FE BTS]_[587]_Capacity^2700^NBSC01 ^AIS_FE_BTS
[AIS FE BTS]_[587]_Capacity^2700 ^NBSC01 ^AIS_FE_BTS
[Lb Interface basic]_[16]_Capacity^1^NBSC01 ^Lb_Interface_basic
[Lb Interface basic]_[16]_Capacity^1 ^NBSC01 ^Lb_Interface_basic
[Lb AGPS]_[19]_Capacity^1^NBSC01 ^Lb_AGPS
[Lb AGPS]_[19]_Capacity^1 ^NBSC01 ^Lb_AGPS
[Lb UTDOA]_[20]_Capacity^1^NBSC01 ^Lb_UTDOA
[Lb UTDOA]_[20]_Capacity^1 ^NBSC01 ^Lb_UTDOA
[L3 functionality for ESB switch]_[1234]_Capacity^6^NBSC01 ^L3_functionality_for_ESB_switch

file2
Code:
1234^4
7^16
4^1321
2^1321
14^389
1^1780
13^38
73^584
393^0
591^0
834^0
673^0
909^30
1015^0
1262^1807
1273^0
1219^0
1379^1196
3730^85
1826^3
16^0
19^0
20^0

Hello nypreH,

Could you please check into your Input_file if there are garbage characters in the Input_files mentioned by you by doing following.
Code:
cat -v Input_file1

If above gives garbage characters then you could do following to remove them.
Code:
tr -d '\r' < Input_file1 > new_Input_file1
tr -d '\r' < Input_file2 > new_Input_file2
mv new_Input_file1  Input_file1
mv new_Input_file2  Input_file2

Then could you please try my command in POST#4 and let us know how it goes then.

Thanks,
R. Singh
# 7  
Old 06-17-2016
This is more like the post#2
Code:
awk 'BEGIN {oFS=FS} NR==FNR {A[$1]; next} {split($2, B, oFS)} (B[1] in A)' Input_file2 FS="Capacity" Input_file1
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print line if values in fields matches number and text

datafile: 2017-03-24 10:26:22.098566|5|'No Route for Sndr:RETEK RMS 00040 /ZZ Appl:PF Func:PD Txn:832 Group Cntr:None ISA CntlNr:None Ver:003050 '|'2'|'PFI'|'-'|'EAI_ED_DeleteAll'|'EAI_ED'|NULL|NULL|NULL|139050594|ActivityLog| 2017-03-27 02:50:02.028706|5|'No Route for... (7 Replies)
Discussion started by: SkySmart
7 Replies

2. Linux

Print line 1 if line 3 matches of the output

Hi I want to extend following command so that on the basis of "Branch: ****" on the third line I can grep and print name of the file on the first line. cat .labellog.emd | grep DA2458A7962276A7E040E50A0DC06459 | cut -d " " -f2 | grep -v branch_name | xargs -I file <command to describe> file ... (1 Reply)
Discussion started by: ezee
1 Replies

3. Shell Programming and Scripting

How to print line if two lines above it matches patterns.?

Hi, I could only find examples to print line before/after a match, but I'd need to print line after two separate lines matching. E.g.: From the below log entry, I would need to print out the 1234. This is from a huge log file, that has a lot of entries with "CLIENT" and "No" entries (+ other... (3 Replies)
Discussion started by: Juha
3 Replies

4. Shell Programming and Scripting

Print entire line only if certain fixed character matches the string

Hi All, I have a file testarun.txt contains the below lines and i want to print the lines if the character positions 7-8 matches 01. 201401011111 201401022222 201402013333 201402024444 201403015555 201403026666 201404017777 201404028888 201405019999 201405020000 I am trying the... (4 Replies)
Discussion started by: Arunprasad
4 Replies

5. Shell Programming and Scripting

awk to print the line that matches and the next if line is wrapped

I have a file and when I match the word "initiators" in the first column I need to be able to print the rest of the columns in that row. This is fine for the most part but on occasion the "initiators" line gets wrapped to the next line. Here is a sample of the file. caw-enabled ... (3 Replies)
Discussion started by: kieranfoley
3 Replies

6. Shell Programming and Scripting

Using regex's from file1, print line and line after matches in file2

Good day, I have a list of regular expressions in file1. For each match in file2, print the containing line and the line after. file1: file2: Output: I can match a regex and print the line and line after awk '{lines = $0} /Macrosiphum_rosae/ {print lines ; print lines } ' ... (1 Reply)
Discussion started by: pathunkathunk
1 Replies

7. UNIX for Advanced & Expert Users

Print line if subsrt matches array

Hi Folks! im printing all lines where the characters in position 270-271 match 33|H1|HA|KA|26 so i came up with this #!/bin/bash array=(33 H1 HA KA 26 ) for i in "${array}" do #echo $i awk '{ if (substr($0,270,2)~'/$i/') print; }' $1 >> $1.temp done It works fine . but... (2 Replies)
Discussion started by: phpsnook
2 Replies

8. Shell Programming and Scripting

How to print line if field matches?

Hi all, I got several lines line this a b c d e 1 e a 1 c d e 3 f a b c 1 e 8 h a b c d e 1 w a 1 c d e 2 w a b c d e 1 t a b c d e 7 4 How can I print the line if 1 is the field one before the last field? Basicly this 2 field ? a b c d e 1 e a b c d e 1 t The file I got is... (7 Replies)
Discussion started by: stinkefisch
7 Replies

9. Shell Programming and Scripting

Print line if first Field matches a pattern

Hi All, I would like my code to be able to print out the whole line if 1st field has a dot in the number. Sample input and expected output given below. My AWK code is below but it can;t work, can any expert help me ? Thanks in advance. {if ($1 ~ /*\.*/) { print $0 }} Input: ... (2 Replies)
Discussion started by: Raynon
2 Replies

10. Shell Programming and Scripting

print next line if matches a particular word..need help

Hi i need a help for making a script whch can print next line if it matches a particular word like file1 have ename Mohan eid 2008 ename Shyam eid 345 if scipt got Mohan it will print next line (eid 2008) pls help me .......:) (2 Replies)
Discussion started by: anish19
2 Replies
Login or Register to Ask a Question