Need to select some column from file1 if condition match.

vijay_rajni · July 4, 2013, 4:55pm

I have two files file1.txt and file2.txt.

want to print some column(number,status,date1,date2,description(descrption column end before category column start with'Oracle Services') and assigned_to column from file1.txt ...If the assigned_to name in file2.txt matches with assinged_to name in file1.

file1.txt
----------

number status  date1  date2     description                                              category                              type                 service  assigned_to     reported_to  envioment 
=====  ====   ===      =====    =============                                             =============                        =====             =======  =========     ======== ======
34567 open 27/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading init Oracle Services - Trouble Tk Ticket, Auto ��� DBA_SERVICE chadda,Deepak kumar  DBA PROD
45678 open 27/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading Sizing Oracle Services - Trouble Tk Ticket, Auto ��� DBA_Ticket chadda,Deepak kumar  DBA TEST
43567 open 27/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading DBMS info Oracle Services - Trouble Tk Ticket, Auto ���  DBA_Group chadda,Deepak kumar  DBA QUALITY
24578 open 28/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading Trig/Proc/Syn Oracle Services - Trouble Tk Ticket, Auto ���  DBA_GrouP Sharma,Vijay Kumar  DBA PROD
45890 open 28/06/13 28/06/13  nl21a00is-centerdb001:testingQA:FSFO has configuration errors Oracle Services - Trouble Tk Ticket, Auto ���  SA_SERVICE Reddy,Ajay rao   DBA PROD
43599 open 27/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading DBMS info Oracle Services - Trouble Tk Ticket, Auto ���  DBA_Group Agarwal,ravi kumar  DBA QUALITY
25578 open 28/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading Trig/Proc/Syn Oracle Services - Trouble Tk Ticket, Auto ���  DBA_GrouP Pandit,Ashok Kumar  DBA PROD
51890 open 28/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading init Oracle Services - Trouble Tk Ticket, Auto ���  SA_SERVICE Reddy,Ajay rao   DBA PROD

file2.txt
----------
Assigned_to
===========
Sharma,Vijay Kumar
Soni,Amit Kumar
Rajput,Anupam 
chadda,Deepak kumar
Thakral,Raj Singhalese
Sahu,chanchal ram
Reddy,Ajay rao

desirous output 

34567 open 27/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading init chadda,Deepak kumar 
45678 open 27/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading Sizing chadda,Deepak kumar 
43567 open 27/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading DBMS info chadda,Deepak kumar 
24578 open 28/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading Trig/Proc/Syn Sharma,Vijay Kumar 
51890 open 28/06/13 28/06/13  nl21a00is-centerdb001:ncdbareq:Error in loading init Reddy,Ajay rao

bartus11 · July 4, 2013, 5:05pm

Your input file is really badly delimited... Anyway try this:

awk 'NR==FNR&&NR>2{a[$0]=1}NR!=FNR{for (i in a) if ($0~i) {x=match($0,"Oracle Services");print substr($0,0,x-2),i}}' file2.txt file1.txt

vijay_rajni · July 4, 2013, 6:33pm

bartus11:

Your input file is really badly delimited... Anyway try this:
awk 'NR==FNR&&NR>2{a[$0]=1}NR!=FNR{for (i in a) if ($0~i) {x=match($0,"Oracle Services");print substr($0,0,x-2),i}}' file2.txt file1.txt

This looks good. can you please explain me this code.