Sed/Awk Help needed

Shell Programming and Scripting
1

Hello All,

Does anybody know how to extract the entries from the 1st and second column that match a multiple regex expression using either sed or awk?

I have a 40 k file with the data that looks like this.

2 VZudbEE.ds_HP11i-726..>
2 VZudbEEE.ds_IB-726-5..>
2 VZudbESA.ds_IB-51-v8..>
2 VZudbESE.ds_HP11i-v8..>
2 VZudbESE.ds_HR.Sol8-..>
2 VZudbESE.ds_IB-v81-F..>
2 VZudbESE.ds_IB1-v81-..>
2 VZudbESE.ds_Sol9UP-V..>
2 VZudbESE.ds_SpecialB..>
2 VZudbXML.ds_IB-72EE-..>
2 VZudbpkI.ds_IB-72EE-..>
2 VZvbrlic.ds_6.0-bin6..>
2 VZvbrokr.ds_4.5.1.p3..>
2 VZvbrokr.ds_4.51-bin..>

what i would like to do is extract every occurence of 2 in the first column and every occurence of VZ in the second column.

Thanks,

I appreciate the help.

2

Try this:

awk '/^2 VZ/ {print $1" " $2; }' file