print variable in awk


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting print variable in awk
# 1  
Old 05-13-2004
Data print variable in awk

i read the variable ph from file and i wanna to print it in awk.
example
Code:
ph=`cat tmpbatch`
tail h.txt|grep "|        |"|awk -F"|" '{ print "@unpdx.sql",$5 }'"$ph"

i try this but it does not work

Last edited by rbatte1; 06-08-2018 at 08:39 AM..
# 2  
Old 05-13-2004
try using the -v switch when passing variables into Awk

Code:
awk -v foo=$ph ......

Here is a link Using Shell Variables in Awk

Last edited by rbatte1; 06-08-2018 at 08:39 AM..
# 3  
Old 05-15-2004
Java i need more

i try it but it does not work it give me error
suppose "ph" is a variable were calculated before
Code:
ph= bla bla bla
and i have an input file as
aaa|1234
bbb|6325
ccc|7454
aaa|5467

i wanna to print in out put file second field of the line that contian aaa and at the end of each line the value of the variable.
so the output will be

1234 bla bla bla
5467 bla bla bla

and thnx in advance

Last edited by rbatte1; 06-08-2018 at 08:39 AM..
# 4  
Old 05-15-2004
For something like this, i would think you would want to use an egrep or grep expression. I dont think (or dont know how) to use a variable passed into Awk as a pattern to search. But you can do something like this, thought it may not run too fast.

Code:
awk -v ph=bbb 'BEGIN{ FS="|" ; OFS=" " } {if($1 ==ph) {print $2, $1}} ' file


Last edited by rbatte1; 06-08-2018 at 08:39 AM..
# 5  
Old 05-15-2004
If I read the question right....

Code:
awk -v ph="bla bla bla" 'BEGIN{ FS="|";OFS=" "} /aaa/{print $2, ph}'  file


Last edited by rbatte1; 06-08-2018 at 08:39 AM..
# 6  
Old 05-16-2004
PHP print variable in awk

i try the folowing code "just for testing" i get the following error
Code:
operate >tail ACCL.txt|awk -v ph="bla bla bla" '{print $2, ph}'
awk: syntax error near line 1
awk: bailing out near line 1
and does this work if i ph calculated by exprestion as
ph = `cat file`


Last edited by rbatte1; 06-08-2018 at 08:39 AM..
# 7  
Old 05-16-2004
What system are you using? Run "uname -a" and post the results.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk print columns and variable

Hi, Can anyone help with the below please? I have written some code which takes an input file, and and prints the contents out to a new file - it then loops round and prints the same columns, but increments the ID column by 1 each time. Input file; NAME,1,15-Dec-15, NAME,1,21-Dec-15,... (9 Replies)
Discussion started by: Ads89
9 Replies

2. Shell Programming and Scripting

Variable won't print out - awk

done. (1 Reply)
Discussion started by: myaa02
1 Replies

3. Shell Programming and Scripting

awk print variable then fields in variable

i have this variable: varT="1--2--3--5" i want to use awk to print field 3 from this variable. i dont want to do the "echo $varT". but here's my awk code: awk -v valA="$varT" "BEGIN {print valA}" this prints the entire line. i feel like i'm so close to getting what i want. i... (4 Replies)
Discussion started by: SkySmart
4 Replies

4. Shell Programming and Scripting

awk print using a variable

hey, just want to ask how to do this. ex. g="hi i am john" h=`echo $g | awk '{print $2}'` echo $h OUTPUT is 'i' What if I want to use a variable instead of using '2', how do I do that? Because this one does not work: a=2 h=`echo $g | awk '{print ${$a}}'` this one also does not... (3 Replies)
Discussion started by: h0ujun
3 Replies

5. Shell Programming and Scripting

awk print variable

I have list of files: ls a.pdf b.pdf c.pdf and so on... and I have a file like this: cat file1 apple mango pear and so on... I want to rename my file like this: (7 Replies)
Discussion started by: zorrox
7 Replies

6. Shell Programming and Scripting

awk print redirection to variable file name

Hello, i need to redirect the output of print to a variable file name: #This is normal awk '{ print $17 > "output.txt" }' input #I need something like this awk '{ print $17 > "output_${25}.txt" }' input how to format the output file name to contain a variable? (6 Replies)
Discussion started by: nazeeb
6 Replies

7. Shell Programming and Scripting

How to print a value in the variable using awk ?

:b:Hi All, I have a part of a script below: var1="value1" awk 'BEGIN {printf("%36s \n ","value1")}' Instead of directly giving the "value1" , I need to give using "var1" in the above awk statement. Is this possible? If so, what is the modified awk command? Thanks in advance JS (1 Reply)
Discussion started by: jisha
1 Replies

8. Shell Programming and Scripting

print variable in file using awk

hi, i have store variable in $var i want to print it in $3 of file using awk. how can i do it? file : var1,var2,var3 var5,var6,var7 var8,var9,var10 . . . i want to print $var in $3 ( for example var3 or var7 or var10) thanks (3 Replies)
Discussion started by: kamel.seg
3 Replies

9. Shell Programming and Scripting

variable inside awk '{print $c}'

i'm trying to do this (in bash darwin); echo "give me some words: " read a c=2 # this is get by other ways echo $a | awk '{print $c}' # i want to print the column given # by de $c variable if there is someone understand what i pretend... (3 Replies)
Discussion started by: Tártaro
3 Replies

10. Shell Programming and Scripting

can awk print column using a variable ??

i want to print the column file using awk or cut in dynamic manner like trmp=2;temp1=1;temp3=2 awk 'BEGIN{OFS=IFS="\t"} {print $temp,$temp1,$temp3}' client_data.txt or cut -f $temp1,$temp2,$temp3 -d"\t" file_name . but it is showing error , In awk can i use variable as in printing... (36 Replies)
Discussion started by: jambesh
36 Replies
Login or Register to Ask a Question