Search Results

Hi I am trying to find a pattern match with column one containing 3 numbers.

input file tmp.lst

abcd456|1|23123|123123|23423
kumadff|a|dadfadf|adfd|adfadfadf...

Thanks a lot srini. It worked. i was struggling to add the table column at the last.

Thanks franklin :)

Thanks sahoo but its partially working.

I need $1,$2,$3 of test file and $0/$1 of the list file.
but currently i am getting $4 of the test file in which i want to search for string but get rid of...

this is the requirement

list.txt
table1
table2
table3


testfile.txt
name#place#data#select * from table1
name2#place2#data2#select * from table 10 innerjoin table3...