AWK prints a specific line based on a search pattern

Question

I have two sets of test.csv data.xml files.

I am trying to grep a specific field from test.csv and search for a string in data.xml. If the string is found, print the corresponding string in the test.csv file.

Example

search string - field name 3.

test.csv

111,xxx,serversugar,port90 222,yyy,servertorque,port190 333,aaa,serverastrix,port8080 422,yxy,servertorque,port290 

data.xml

 <group> <hostname>servertorque</hostname> <hostname>serverastrix</hostname></group> 

Expected Result

 222,yyy,servertorque,port190 333,aaa,serverastrix,port8080 422,yxy,servertorque,port290 

Answer 1

with GNU sed and grep in 2 steps

 sed '/>\w\+</!d;s/.*>\(\w\+\).*/\1/' data.xml>pattern.txt grep -wf pattern.txt test.csv 

.. output:

  222, yyy, servertorque, port190
 333, aaa, serverastrix, port8080
 422, yxy, servertorque, port290

Answer 2

One way: awk

 awk -v FS="[><,]" 'NR==FNR{a[$3]++;next}$3 in a' data.xml test.csv 

Test:

 $ cat data.xml <group> <hostname>servertorque</hostname> <hostname>serverastrix</hostname></group> $ cat test.csv 111,xxx,serversugar,port90 222,yyy,servertorque,port190 333,aaa,serverastrix,port8080 422,yxy,servertorque,port290 $ awk -v FS="[><,]" 'NR==FNR {a[$3]++;next} $3 in a' data.xml test.csv 222,yyy,servertorque,port190 333,aaa,serverastrix,port8080 422,yxy,servertorque,port290 

Answer 3

I assume you need:

 awk -F',' '$3==<string_you_need> { print $0 }' test.csv