How to print using awk?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to print using awk?
# 1  
Old 11-15-2015
How to print using awk?

Hi All

I have stored my column position in a variable. This variable is derived using some logic

Code:
x='$3,$4,$5'

now I want to use that variable and want to print the data using awk

awk  -F"|"  "{print ${x} }"  sourcefile

The awk command should print 3rd,4th and 5th column of the file.I tried below command but it didn't worked.
Code:
 awk  -v row="'$x'" -F"|"  '{print row}'  sourcefile


Last edited by gvkumar25; 11-15-2015 at 05:59 AM..
# 2  
Old 11-15-2015
You can't assign a shell variable with a leading $ sign. Try without.
# 3  
Old 11-15-2015
Hi Rudic,

Thanks for your reply its typo mistake. I corrected the #1 post.

My code was without $ only. It is not working
# 4  
Old 11-15-2015
DON'T edit posts when others answered and referred to it. It makes the answer look inapt.

Your first code snippet, although not the recommended solution, did work when x had the right contents. Did you confirm that?

---------- Post updated at 11:09 ---------- Previous update was at 11:05 ----------

It is working (linux, bash 4.3.42(1)-release):

Code:
x='$3,$4,$5'
set -vx
awk  -F"|"  "{print ${x} }" file
+ awk '-F|' '{print $3,$4,$5 }' file
emanger esal ecity
larry $2000 melbourne
Peter $1000 sydney

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 count for column in a file using awk

Hi, I have the following input in a file & need output as mentioned below(need counter of every occurance of field which is to be increased by 1). Input: 919143110065 919143110065 919143110052 918648846132 919143110012 918648873782 919143110152 919143110152 919143110152... (2 Replies)
Discussion started by: siramitsharma
2 Replies

2. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

3. Shell Programming and Scripting

AWK print AWK command

awk '{print "awk '{sub(/pdb_00/,"pdb_"$0"_00"); print}' pdb_"$0"_00.namd > tempo"; print "mv tempo pdb_"$0"_00.namd"}' datA2.dat > copy_script2.bash This works when trying to print 'sed etc. etc' but if I switch to using AWK to print a set of AWK commands it doesn't work... e.g. this... (3 Replies)
Discussion started by: chrisjorg
3 Replies

4. UNIX for Advanced & Expert Users

awk print help

In this: $ awk '{ print "var is", var }' var=TEST file1 What does the print part do? { print "var is", var } (4 Replies)
Discussion started by: cokedude
4 Replies

5. Shell Programming and Scripting

Print using awk

Hi.. I have two files. contents of the files are as below. header1.dat ------------- This is a header record. header2.dat ------------- This is a header record. Date:2011-01-05 I am executing the below scripts. HEADER1=`cat header1.dat` HEADER2=`cat header2.dat` awk 'BEGIN... (2 Replies)
Discussion started by: 46019
2 Replies

6. Shell Programming and Scripting

print through AWK

Hi friends I need one help from you . I want to print name='JACK' through . how can i make it . awk '{print "name=jack"}' it ll print name=JACK (6 Replies)
Discussion started by: imipsita.rath
6 Replies

7. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies

8. Shell Programming and Scripting

Awk and print help

Hello I have a log file like so 2009-01-15 17:55:06 H=host-216-153-217-114.spr.choiceone.net :30675 I=:25 F=<> rejected RCPT <feast@test.co.uk>: DNSBL listed at sbl-xbl.spamhaus.org What I am trying to do is be able to print x amount of columns after a certain part of the line say F= grep... (1 Reply)
Discussion started by: casseyjon
1 Replies

9. Shell Programming and Scripting

How do I get awk to print a " in it's print part?

The line is simple, use " '{ print $1"]"$2"\"$3THE " NEEDS TO GO HERE$4 }' I've tried \", "\, ^" and '"" but none of it works. What am I missing? Putting in the [ between $1 and $2 works fine, I just need to do the same with a ". Thanks. (2 Replies)
Discussion started by: LordJezo
2 Replies

10. UNIX for Dummies Questions & Answers

awk print $2

/oracle/ID1/saparch"|awk '{print $2}' what does print $2 means? (1 Reply)
Discussion started by: yls177
1 Replies
Login or Register to Ask a Question