How to use shell variable in awk?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to use shell variable in awk?
# 1  
Old 04-10-2012
How to use shell variable in awk?

How do you use a shell variable in awk? I am using Solaris 10 and don't have GNU products installed.

File (transportation.txt) contents:
Code:
car
boat 
airplane
snowmobile
bicycle
sled

This awk statment works (prints from the car line down to bicycle
Code:
awk '/car/,/bicycle/' transportation.txt

But what if instead of car I use a shell variable named vehicle (where the variable can be any value) passed by the user?

This line doesn't work (what's missing?)
Code:
awk '/$vehicle/,/bicycle/' transportation.txt


Last edited by Franklin52; 04-11-2012 at 03:39 AM.. Reason: Please use code tags for code and data samples, thank you
# 2  
Old 04-10-2012
# 3  
Old 04-10-2012
Thanks for the info. How do you apply the first way and second way to my awk command line. Sorry, I'm new to awk.

---------- Post updated at 09:19 PM ---------- Previous update was at 08:09 PM ----------

Will this work?
Code:
awk 'END{'/a/,/bicycle/}' a=$vechicle transportation.txt

thanks for the help.......

Last edited by Franklin52; 04-11-2012 at 03:40 AM.. Reason: Please use code tags for code and data samples, thank you
# 4  
Old 04-10-2012
Code:
vechicle="car"
awk '/'$vehicle'/,/bicycle/' transportation.txt

Since you are using '/.../' , second way cannot be used.
This User Gave Thanks to chihung For This Post:
# 5  
Old 04-10-2012
Do I need the first line if $vechicle is defined elsewhere? $vehicle with be defined by the user and set in the script. set vechicle=$argv[1].
# 6  
Old 04-10-2012
You should have nawk on a Solaris 10 box, so either of these should work and avoid any nasty quoting games:

Code:
awk 'match( $0, v ),/bicycle/' v="$vehicle" input-file

nawk -v v="$vehicle" 'match( $0, v ),/bicycle/' input-file

And, as long as vehicle is set before you use it, you should be fine.

Last edited by agama; 04-10-2012 at 11:50 PM.. Reason: additional info -- fixed typo
This User Gave Thanks to agama For This Post:
# 7  
Old 04-10-2012
Agama, can you explain the lines of code? How does it know to stop searching at bicycle? Should the bar part of your code be bicycle?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How can I assign awk's variable to shell script's variable?

I have the following script, and I want to assign the output ($10 and $5) from awk to N and L: grdinfo data.grd | awk '{print $10,$5}'| read N L output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use... (8 Replies)
Discussion started by: geomarine
8 Replies

2. Shell Programming and Scripting

Shell variable expansion in awk

I want to split one file input.tab into two separate ones, odd lines to input_reads1.txt, even lines to input_reads2.txt for a serial of files with similar name pattern. Also I want to "match" input/output file names to keep consistency of file name: CSEL_02.0_input.tab CSEL_03.4_input.tab... (2 Replies)
Discussion started by: yifangt
2 Replies

3. Shell Programming and Scripting

Awk: How to get an awk variable out to the shell, using system() ?

I am reasonably capable with awk and its quirks, but not with shell weirdness. This has to be Bourne Shell for portability reasons. I have an awk program that is working just fine; it handles multiple input streams and produces several reports, based on the request (-v Variables). In addition... (3 Replies)
Discussion started by: DerekAsirvadem
3 Replies

4. Shell Programming and Scripting

use shell variable in awk command

Trying to do something like this ls -lrt | awk '$9=="test5"' -rw-r--r-- 1 lrmq db2iadm1 381 Sep 20 21:56 test5 But now, I need to give a variable in place of test5. For example let's define x as test5 x=test5 ls -lrt | awk '$9=="$x"' This doesn't seem to be working. It doesn't take the... (4 Replies)
Discussion started by: blazer789
4 Replies

5. Shell Programming and Scripting

Shell variable in awk

I have 3 files and each contain m*n matrix. m = number of rows (horizontal lines) n = number of columns (entries in a particular line) What I wish to find is the sum of the 2nd number in the last row. Ex file1.dat 2 5 8 8 4 6 7 8 3 8 3 7 file2.dat 3 4 1 4 8 4 0 3 4 7 3 7 ... (3 Replies)
Discussion started by: dynamics
3 Replies

6. Shell Programming and Scripting

How to change awk and shell variable value?

In awk script, #!/bin/sh awk 'BEGIN{i=0;}{i=i+5;}END{print i}' in.txt vr=0; vr=$i; echo "$vr" How can i assign that value of i in $vr(variable) of shell script? (7 Replies)
Discussion started by: cola
7 Replies

7. Shell Programming and Scripting

assign awk's variable to shell script's variable?

Dear All, we have a command output which looks like : Total 200 queues in 30000 Kbytes and we're going to get "200" and "30000" for further process. currently, i'm using : numA=echo $OUTPUT | awk '{print $2}' numB=echo $OUTPUT | awk '{print $5}' my question is : can I use just one... (4 Replies)
Discussion started by: tiger2000
4 Replies

8. Shell Programming and Scripting

Return Awk Variable to Shell

I'm a bit stuck in getting variable from awk to shell. I tried searching but most of them showing to assign to shell variable via.. VAR=`echo $line | awk -F: '{print $1}'` which is correct ofcourse My problem is multiple assignments of variable like this one. The above solution will give... (10 Replies)
Discussion started by: ryandegreat25
10 Replies

9. Shell Programming and Scripting

Shell variable with awk

line_no=6 echo 'Phone,' `awk 'NR==$line_no{print;exit}' <filename>` what is the error in this.. it says.. awk: Field $() is not correct. The input line number is 1. The file is <filename>. The source line number is 1. i want to print the data in the $line_no line of a certain... (2 Replies)
Discussion started by: St.Fartatric
2 Replies

10. Shell Programming and Scripting

shell variable in awk

Hi All, How can i use the file for printing in awk file1 ---------- update table crn_ras_disc_dtl a set a.a5=$1,a.a1=$2,a.a2=$3,a.a3=$4,a.a4=$5; file2 -------- 10|KUMAR|23|MALE|US 20|RAJ|24|MALE|AU Output --------- update table crn_ras_disc_dtl a set... (12 Replies)
Discussion started by: cskumar
12 Replies
Login or Register to Ask a Question