Sponsored Content
Top Forums UNIX for Dummies Questions & Answers awk to print ' (single quotes) Post 302174612 by orahi001 on Tuesday 11th of March 2008 03:15:04 PM
Old 03-11-2008
awk to print ' (single quotes)

I'm building a file with sql delete statements. I need to print the single quotes for the where clause.

i.e.
delete from Command where CommandName = 'SomeName';

I have the following in my script

input=$(pwd)/Cmnd.csv

i=0

while read line
do
if test $i -ge 1;
then
echo "$line" | awk -F'|' '{print "delete from Command where CommandName='"$1"';}' >> deleteCmd.dat

fi

i=$i+1
done < $input

This gives me:
delete from Command where CommandName=;

how do I print the (single quotes) ' with awk?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

single quotes in awk statement

Hi, I have written a code to modify a string say, StringA=abc,def,ghi I need to change it to something like: StringB=This means abc='ABC', This mean def='DEF', This means ghi= 'GHI' StringB=$(echo $StringA | awk -F',' 'BEGIN { OFS="," } { for (i=1; i<=NF;i++) $i="This means... (2 Replies)
Discussion started by: tostay2003
2 Replies

2. Shell Programming and Scripting

How to alias an awk command with single and double quotes?

Hi, I am trying to write the following command as an alias in my .bashrc file. bjobs -u all | awk '{if (NR > 1) {username++;}}END{{print"\nJOBS BY USER:\n"} for (i in username) {print username,i;}{print"\n Total Jobs=",NR-1,"\n" }}' The command simply puts how many jobs each user is... (2 Replies)
Discussion started by: jacekmaciek
2 Replies

3. Shell Programming and Scripting

Having a terrible problem with quotes/single quotes!

Hello. I'm trying to write a bash script that uses GNU screen and have hit a brick wall that has cost me many hours... (I'm sure it has something to do with quoting/globbing, which is why I post it here) I can make a script that does the following just fine: test.sh: #!/bin/bash # make... (2 Replies)
Discussion started by: jondecker76
2 Replies

4. Shell Programming and Scripting

awk - single quotes as field separator

How can I use single quotes as field separator in awk? (1 Reply)
Discussion started by: locoroco
1 Replies

5. UNIX for Dummies Questions & Answers

awk for inserting a variable containing single and double quotes

Hi i have to insert the below line into a specific line number of another file export MBR_CNT_PRCP_TYPE_CODES_DEL="'01','02','04','05','49','55','UNK'" I have passed the above line to a variable say ins_line. I have used below command to perform the insert awk 'NR==3{print "'"${ins_line}"'"}1'... (1 Reply)
Discussion started by: sathishteradata
1 Replies

6. Shell Programming and Scripting

awk - single quotes as record separator

How do I use single quotes as record separator in awk? I just couldn't figure that out. I know how to use single quotes as field separator, and double quotes as both field and record separator ... (1 Reply)
Discussion started by: locoroco
1 Replies

7. Shell Programming and Scripting

Unable to echo single quotes inside awk

# echo 'export HISTFILE=/var/log/history/history_$(uname -n)_$(date +%Y:%b:%d:%H:%M)_$(who am i | awk '{print \$1}')' >> new_file # # cat new_file export HISTFILE=/var/log/history/history_$(uname -n)_$(date +%Y:%b:%d:%H:%M)_$(who am i | awk {print $1}) # Now how to echo the quotes around the... (2 Replies)
Discussion started by: proactiveaditya
2 Replies

8. Shell Programming and Scripting

Issue with Single Quotes and Double Quotes for prompt PS1

Hi, Trying to change the prompt. I have the following code. export PS1=' <${USER}@`hostname -s`>$ ' The hostname is not displayed <abc@`hostname -s`>$ uname -a AIX xyz 1 6 00F736154C00 <adcwl4h@`hostname -s`>$ If I use double quotes, then the hostname is printed properly but... (3 Replies)
Discussion started by: bobbygsk
3 Replies

9. Shell Programming and Scripting

awk - Print where value is in quotes

Hi All, I have input data like follows: "1234"|"ABC" "1234"|"CBA" "1222"|"ZZZ" I am trying to awk print all records where Col1 = "1234". Below is the code I have so far: Var1=1 Var2=1234 awk -F "|" "$ ${Var1} == "\"${Var2}\"" { print; }' inputfile However when the AWK... (2 Replies)
Discussion started by: RichZR
2 Replies

10. Shell Programming and Scripting

Single quotes insert statement using awk

Hi, Need help, using awk command to insert statement awk -v q="'" '{ print "db2 connect to repolab > /dev/null; " "\n" "db2 -x \" select name from IBMPDQ.PROFILE where managed_database = " q $1"_"$3"__0" q "\"" } ' profile.txt | sh - | awk -v i="'" ' { print "db2 connect to repolab >... (1 Reply)
Discussion started by: Mathew_paul
1 Replies
rndc.conf(4)						     Kernel Interfaces Manual						      rndc.conf(4)

NAME
rndc.conf - rndc configuration file DESCRIPTION
is the configuration file for the BIND 9 name server control utility. This file has a structure and syntax similar to the configuration file, The standard (default) configuration file is located at The standard (default) configuration file is located at Syntax The syntax of the file is much simpler than that of the configuration file. It includes three statements and optional comments. Statement blocks are enclosed in braces and terminated with a semicolon. Clauses in the statements are also semicolon-terminated. A servername or keyname must be quoted using double quotes if it matches a keyword, such as having a key named . The options Statement The statement specifies the default server and key definition for the configuration. The clause specifies the default server on which runs, if the server is not specified with the option in the command. defserver is the name or IP address of a name server that is specified in a statement. The clause specifies the default key that will authenticate the server's commands and responses if a key is not specified with the option in the command. defkey is the name of a key that is specified in a statement. The server Statement The statement specifies the servername of a name server, as a host name or an IP address. The clause specifies a keyname that matches a keyname in a statement. Multiple statements are permitted. The key Statement The statement specifies the name, keyname, and definition of a key. The clause identifies the encryption algorithm, algoname. Currently only is supported. The clause contains the random key, secretvalue, that will be used for authentication. It is base-64-encoded, using the algorithm speci- fied in the clause. secretvalue is enclosed in double quotes. The BIND 9 program can be used to generate the secretvalue. Multiple statements are permitted. Comments The following comment styles are supported: C: C++: UNIX: Name Server Configuration The name server must be configured to accept connections and to recognize the key specified in the file, using the statement in WARNINGS
Currently, there is no way to specify the port on which must run. EXAMPLES
Example 1 Here is a sample file: In this example, will, by default, use the server at (127.0.0.1) and the key named Commands directed to the server will use the key. The statement indicates that uses the HMAC-MD5 algorithm and its clause contains the base-64 encoding of the HMAC-MD5 secret enclosed in double quotes. Example 2 To generate a random secretvalue with the command (see rndc-confgen(1)): A complete file, including the randomly generated key, is written to standard output. Commented-out and statements for are also written. Example 3 To generate the secretvalue with the command (see dnssec-keygen(1)): The base-64 secretvalue will appear in two files, and After you copy the secretvalue into statements in the and files, you can delete the and files. AUTHOR
was developed by the Internet Systems Consortium (ISC). SEE ALSO
dnssec-keygen(1), rndc(1), rndc-confgen(1), named(1M). available online at available from the Internet Systems Consortium at BIND 9.3 rndc.conf(4)
All times are GMT -4. The time now is 05:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy