Visit Our UNIX and Linux User Community


how to print single quote in awk


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers how to print single quote in awk
# 1  
Old 03-16-2006
how to print single quote in awk

Hi all,

It is a very stupid problem but I am not able to find a solution to it.

I am using awk to get a column from a file and I want to get the output field in between single quotes. For example,

Input.txt

123 abc
321 ddff
433 dfg
........

I want output file to be as
output.txt

value is 'abc'
value is 'ddff'
value is 'dfg'
...............

the problem is how to get these single quotes in output, at this moment I am first taking *abc* and then replacing * with ' (single quote).
How can we do this with awk

thanks
Gaurav
This User Gave Thanks to gauravgoel For This Post:
# 2  
Old 03-16-2006
Show the awk syntax you are using as part of the script and the input data.
# 3  
Old 03-16-2006
Code:
nawk -v q="'" '{print q $2 q}' Input.txt

# 4  
Old 03-16-2006
Or use the ascii value...
Code:
awk '{print "\x27" $2 "\x27"}'

# 5  
Old 03-17-2006
Hi All,
vgersh and ygor thanks a lot for the help, both the above things are working perfectly fine.

Hugow thanks a lot for your time, the awk syntax which I will be using now is

Quote:
awk -v q="'" '{print "value is" q $2 q}' inputfile
or
Quote:
awk '{print "value is \x27" $2 "\x27"}' inputfile
Thanks and regards,
Gaurav
# 6  
Old 10-16-2007
a remarkable sequence of quote characters

awk '{ print "value is '"'"'" $2 "'"'"'" }' input.txt

which prints

value is 'abc'
value is 'ddff'
value is 'dfg'
# 7  
Old 08-20-2008
easier way

awk '{ print "value is","'\''" $2 "'\''" }' input.txt

does the same thing but may be easier to understand
This User Gave Thanks to protargol For This Post:
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #735
Difficulty: Medium
The Commodore 64 was shipped with BASIC v2.0 in RAM.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk: single quote match in If

Hello, I'd like to print line if column 5th doesn't match with exm. But to reach there I have to make sure I match single quote. I'm struggling to match that. I've input file like: Warning: Variants 'exm480340' and '5:137534453:G:C' have the same position. Warning: Variants 'exm480345'... (9 Replies)
Discussion started by: genome
9 Replies

2. Shell Programming and Scripting

Help required to Print Single quote into a file

Hi, I need help in printing string enclosed with single quotes to a file. I am trying to write a shell script which when run will create another script below is the script logic. cat create_script.sh echo '#!/bin/sh' > append_flname.sh echo 'for FILE in $*' >> append_flname.sh echo... (6 Replies)
Discussion started by: imrandec85
6 Replies

3. Shell Programming and Scripting

Replacing all but the first and last double quote in a line with a single quote with awk

From: 1,2,3,4,5,This is a test 6,7,8,9,0,"This, is a test" 1,9,2,8,3,"This is a ""test""" 4,7,3,1,8,"""" To: 1,2,3,4,5,This is a test 6,7,8,9,0,"This; is a test" 1,9,2,8,3,"This is a ''test''" 4,7,3,1,8,"''"Is there an easy syntax I'm overlooking? There will always be an odd number... (5 Replies)
Discussion started by: Michael Stora
5 Replies

4. Shell Programming and Scripting

How to use awk in inserting single quote

Hi Guys, Please someone help me to insert these numbers (enclosed with single quotes) to a statement using awk command. I'm having hard time of putting single quotes on these numbers. input file: 10214 68441 07205 80731 92234 55432 DESIRED OUTPUT: My ID Number='10214';... (1 Reply)
Discussion started by: pinpe
1 Replies

5. Shell Programming and Scripting

How do you print a single quote character in AWK

How do you print out a single quote character in AWK? Using the escape character does not seem to work. {printf "%1$s %2$s%3$s%2$s\n" , "INCLUDE", " \' ", "THIS" } does not work. Any suggestions? (6 Replies)
Discussion started by: cold_Que
6 Replies

6. Shell Programming and Scripting

awk print: howto single quote not interpreted!?

cat a | awk -F";" '{print "update db set column=' "$2" ' where column1=\""$1"\";"}' > ip-add.sql Hi! I'm a new user! i need to use single quote in the double quotes print string The apex between che "$2" should not be interpreted, but....how?! I'm trying to use \ but don't work correctly! ... (4 Replies)
Discussion started by: Re DeL SiLeNziO
4 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

Regex in grep to match all lines ending with a double quote (") OR a single quote (')

Hi, I've been trying to write a regex to use in egrep (in a shell script) that'll fetch the names of all the files that match a particular pattern. I expect to match the following line in a file: Name = "abc" The regex I'm using to match the same is: egrep -l '(^) *= *" ** *"$' /PATH_TO_SEARCH... (6 Replies)
Discussion started by: NanJ
6 Replies

9. Shell Programming and Scripting

want to print single quote using awk

i want to print ' symbol using awk i tried: awk '{print " ' "}' awk '{print "\' "}' both not work please help me. (2 Replies)
Discussion started by: RahulJoshi
2 Replies

10. Shell Programming and Scripting

AWK handling of single quote

Hi, Can someone let me know how I can acheive the following. I have ~ delimited file and I need to convert into something like SQL insert statements. SrcFile : 1~sjdsdj~asasas~ 2~aaaaa~qwqwqwq~qwq ..... I tried AWK -F"~" '{print "INSERT INTO XX VALUES("$1 " ,\' "$2" \' , \' "$3 }'... (3 Replies)
Discussion started by: braindrain
3 Replies

Featured Tech Videos