Need to search string from file 1 in one of columns of file 2
hello all.
I would like to kindly ask you, if you could help me out with one problem.
I have two files -> for ex. file1 and file2
file1 contains only various numbers
file 2 contains multiple columns with various values
What i need is to take every single number, one by one, from file 1 and check if this number occurs in column 5 of file 2 - doesnt matter if it occurs for several times
4900017287 2011 WA CO11N 49000186672011
4900017288 2011 WA CO11N 49000186682011
4900017289 2011 WA CO11N 49000186692011
4900017290 2011 WA CO11N 49000186702011
4900017291 2011 WA CO11N 49000186712011
4900017292 2011 WA CO11N 49000186722011
4900017293 2011 WA CO11N 49000186732011
4900017294 2011 WA CO11N 49000186742011
4900017296 2011 WA CO11N 49000186762011
Desired output if matching :
Code:
4900017287 2011 WA CO11N 49000186672011 X
4900017288 2011 WA CO11N 49000186682011 X
4900017289 2011 WA CO11N 49000186692011 X
4900017290 2011 WA CO11N 49000186702011 X
4900017291 2011 WA CO11N 49000186712011 X
4900017292 2011 WA CO11N 49000186722011 X
4900017293 2011 WA CO11N 49000186732011 X
4900017294 2011 WA CO11N 49000186742011 X
4900017296 2011 WA CO11N 49000186762011 X
Thank you all in advance for any useful hints.
I tried already some loops, awk searches but without any desired success.
Last edited by Scrutinizer; 12-10-2012 at 04:48 PM..
Reason: code tags
I want to search a small string in a large string and find the locations of the string. For this I used grep "string" -ob <file name where the large string is stored>. Now this gives me the locations of that string. Now how do I store these locations in a text file.
Please use CODE tags as... (7 Replies)
Hi there,
I am new to Unix and had below requirement to finish my task.
I have file1.dat which has data as shown below.
case1.txt
case2.txt
case3.txt
case4.txt
file1.dat has only file names
I have folder which has above files mentioned in file1.dat
./all_files
case1.txt... (6 Replies)
Hi guys,
I have a text file named file1.txt that is formatted like this:
001 , ID , 20000
002 , Name , Brandon
003 , Phone_Number , 616-234-1999
004 , SSNumber , 234-23-234
005 , Model , Toyota
007 , Engine ,V8
008 , GPS , OFF
and I have file2.txt formatted like this:
... (2 Replies)
Hi,
Need your help for this scripting issue I have. I am not really good at this, so seeking your help.
I have a file looking similar to this:
Hello, i am human and name=ABCD.
How are you?
Hello, i am human and name=PQRS.
I am good.
Hello, i am human and name=ABCD.
Good bye.
Hello, i... (12 Replies)
I have file which contains a huge amount of data. I need to search the pattern Message id. When that pattern is matched I need to get abcdeff0-1g6g-91g3-1z2z-2mm605m90000 to another file.
Kindly provide your input.
File is like below
Jan 11 04:05:10 linux100 |NOTICE... (2 Replies)
Dear All
I am having a text file which is having more than 200 lines.
EX:
001010122 12000 BIB 12000 11200 1200003
001010122 2000 AND 12000 11200 1200003
001010122 12000 KVB 12000 11200 1200003
In the above file i want to search for string KVB... (5 Replies)
I am having a text file which is having more than 200 lines.
EX:
001010122 12000 BIB 12000 11200 1200003
001010122 2000 AND 12000 11200 1200003
001010122 12000 KVB 12000 11200 1200003
In the above file i want to search for string KVB and add/replace... (1 Reply)
Hi Guys,
I am trying to write a perl script to search a string "Name" in the file "FILE" and also want to create a new file and push the searched string Name line along with 10 lines following the same.
can anyone of you please let me know how to go about it ? (8 Replies)
i am very new to UNIX
plz help me in this scenario
i have two text files as below
file1.txt
name=Rajakumar.
Discipline=Electronics and communication.
Designation=software Engineer.
file2.txt
name=Kannan.
Discipline=Mechanical.
Designation=CADD Design Engineer.
... (6 Replies)
Hi,
Can anyone help in the below problem.
file1 has the below contents
fileset 999 primary-ilist inode 37020 has invalid dotdot (426094) -> Not exist
fileset 999 primary-ilist inode 115016 dup block ->... (9 Replies)