Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk print: howto single quote not interpreted!?
Top Forums Shell Programming and Scripting awk print: howto single quote not interpreted!? Post 302386923 by Re DeL SiLeNziO on Thursday 14th of January 2010 05:11:50 AM
Old 01-14-2010
awk print: howto single quote not interpreted!?
Code:
 	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!

Thanks!!!!!!
Last edited by Re DeL SiLeNziO; 01-14-2010 at 06:18 AM..
 

10 More Discussions You Might Find Interesting

1. 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

2. UNIX for Dummies Questions & Answers

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 ... (6 Replies)
Discussion started by: gauravgoel
6 Replies

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

LEARN ABOUT DEBIAN

xls2csv

xls2csv(1)						      General Commands Manual							xls2csv(1)

NAME

       xls2csv - reads MS-Excel file and puts its content as comma-separated data on standard output

SYNOPSIS

       xls2csv [-xlV] [-f  format ] [-b  string ] [-s  charset ] [-d  charset ] [-q  number ] [-c  char] files

DESCRIPTION

       xls2csv	reads  MS-Excel  spreadsheet  and  dumps  its content as comma-separated values to stdout. Numbers are printed without delimiters,
       strings are enclosed in the double quotes. Double-quotes inside string are doubled.

OPTIONS

       -x      print unknown Unicode chars as xNNNN, rather than as question marks

       -l      list known charsets and exit successfully

       -cchar  cell separator char. By default - comma.

       -bstring
	       sheet break string. This string (by default - formfeed) would be output at the end of each workbook page. This  string  is  printed
	       after page starting at start of line, but no linefeed would be automatically added at the end of string. Include newline at the ent
	       of sheet separator if you want it to appear on separate line by itself

       -gnumber number of decimal digits in the numbers. By default maximal double precision (system-dependent macro DBL_DIG) is used.

       -qnumber
	       set quote mode. In quote mode 0 cell contents is never quoted.  In quote mode 1 only strings which contain spaces, double quotes or
	       commas are quoted.  In quote mode 2 (default) all cells with type string are quoted.  In quote mode 3 all cells are quoted.

       -dcharset`
	       -  specifies  destination  charset  name.  Charset file has format described in CHARACTER SETS section of catdoc(1) manual page. By
	       default, current locale charset would be used if langinfo support was enabled at the compile time.

       -scharset
	       - specifies source charset. Typically, Excel files have CODE PAGE record, which denotes input charset, but for some reason you  may
	       wish to override it.

       -fformat
	       - specifies date/time format to use for output of all Excel date and time  values.  If this option is not specified, format, speci-
	       fied in the spreadsheet is used. On POSIX system any format, allowed by strftime(3) can be used as value of this option. Under  MS-
	       DOS xls2csv implements limited set of strftime formats, namely m, d, y, Y, b, l, p, H, M, S.

       -V      outputs version number

FILES

       ${HOME}/.catdocrc, catdoc charset files and substitution map files (see catdoc(1) manual page for details,

SEE ALSO

       cat(1), catdoc(1), strings(1), utf8(7), unicode(7)

AUTHOR

       V.B.Wagner <vitus@45.free.net>, based on biffview by David Rysdam

MS-Word reader							  Version 0.94.4							xls2csv(1)
All times are GMT -4. The time now is 10:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy