Awk command in bash using variable

Asked May 29 '18 at 22:22

Active May 29 '18 at 22:22

Viewed 50 times

how can i search the first column of a file and get the corresponding value from second column using variable as search criteria?

I need something like this...

for pdf in $reports
do
id=` less /path/file | awk '$1 == pdf {print $2}'`
do other stuff
done

asked May 29 '18 at 22:22

`less` is not helping you in this case. Decompose your problem to simpler steps. `awk -v var="strVal" '{$1 == var {print $2}' /path/file` is the place to start. Good luck. – shellter May 29 '18 at 22:26
Can you clarify more what the data in the files might look like and what the contents of `$reports` is? – Joshua Smith May 29 '18 at 22:30
@shellter, ...I'm presuming the leading `{` was in error – Charles Duffy May 29 '18 at 22:33
It is a file with 3 columns so i wanna find a match on the first column (matching whatever is in my variable) and get the corresponding value of the second column for that match. – Vandré Dreer Bonaite May 29 '18 at 22:43
@shellter how do i assing the output to a variable? Like id= `awk ....`? – Vandré Dreer Bonaite May 29 '18 at 22:48
It worked! Thanks@ – Vandré Dreer Bonaite May 29 '18 at 22:52
@charlesDuffy , yep, thanks for pointing that out! "Vandré Dreer Bonaite", you were almost there, glad you found your solution! Good luck. – shellter May 29 '18 at 23:25

0 Answers0