08-30-2012
chidori: sorry I forgot to mention the condition.
I cannot use back ticks. Only single quotes are allowed
---------- Post updated at 12:32 PM ---------- Previous update was at 11:36 AM ----------
guruprasadpr: Your idea will work, but im looking for a way to avoid quotes in awk command
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have write this script:
#!/usr/bin/gawk -f
BEGIN {
strins="/usr/bin/mysql --user=user --password=pass -h localhost -D admin_test -e 'INSERT INTO test (id, perc) VALUES ('aaa',0)'"
system(strins)
}
the table test are so defined: id(varchar(10)), perc(int(10))
the error that i... (10 Replies)
Discussion started by: dogo21sob
10 Replies
2. Shell Programming and Scripting
i want to print the statement below using awk,but i am unable to get the quotes
("22345",1,"Thank you");
How can i do this (5 Replies)
Discussion started by: tomjones
5 Replies
3. UNIX for Advanced & Expert Users
Hi all,
I have input lines like below
empno,ename,sal,description
----------------------------
311,"jone,abc",2000,manager
301,david,200,"president,ac"
I need to sum the salary of them i.e. 2000+200
anything suggested
Thanks,
Shahnaz.
Use code tags. (5 Replies)
Discussion started by: shahnazurs
5 Replies
4. Shell Programming and Scripting
Hi
I read somewhere that when using double quotes in awk; variables gets expanded else it doesn't.
So I tried to use the double quotes inside an awk statement as below:
from_instance_trans=`awk "/INPUT =\"$frm_inst\"/,/<\/TRANSFORMATION>/" $xml_object | grep -w "<TRANSFIELD" | awk... (9 Replies)
Discussion started by: dips_ag
9 Replies
5. UNIX for Dummies Questions & Answers
Want to populate double quotes for each filed using awk:
Input: cat file.txt => "1-23-test_test1-test2"
Required output :
"1-23-test_test1-test2"|"#GT_properties_xyz"
Was trying the below command on solaris 9 machine :
awk -F"|" '{print $1"|""#GT_properties_xyz"}' file.txt
... (8 Replies)
Discussion started by: rajachandhok
8 Replies
6. Shell Programming and Scripting
can someone help me with this. i keep getting errors:
var1="MaxClients"
var2="java|could not.*problem found|panic() failure seen|aborting "
awk 'NR>=1&&NR<=10 && /'${var1}'/ && !/'${var2}'/ {++c}c==3{o=$0 RS $0 RS $0; print o; c=0}' log
when i run the above, i keep getting:
awk:... (3 Replies)
Discussion started by: SkySmart
3 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
Hello, i had a problem running a script , and after investigation found its all to do with the quotes:
cat file1
line1
val1
val2
line2
val1
val2
line3
val1
val2
awk 'BEGIN {RS="\n\n"; FS="\n";} {print $1 $2}' file1
This gives me the wrong output: (5 Replies)
Discussion started by: andy391791
5 Replies
9. UNIX for Beginners Questions & Answers
Example:
`abc.ksh | grep '^GLIS'| awk -F' ' '{print \$1}'`; (3 Replies)
Discussion started by: Tanu
3 Replies
10. Shell Programming and Scripting
Hi ALL,
file data like :
test.csv
a,b,"c,d"
my awk version is 4.0.2 ,if i am using the below code is working fine.
awk -vFPAT='(*)|("+")' -vOFS="," '{print $3}' test.csv
if the awk version is 3.1.7 is not working . Could you please help me on this one.
output should be : "c,d" (6 Replies)
Discussion started by: bmk123
6 Replies
SPLIT(1) FSF SPLIT(1)
NAME
split - split a file into pieces
SYNOPSIS
split [OPTION] [INPUT [PREFIX]]
DESCRIPTION
Output fixed-size pieces of INPUT to PREFIXaa, PREFIXab, ...; default PREFIX is `x'. With no INPUT, or when INPUT is -, read standard
input.
Mandatory arguments to long options are mandatory for short options too.
-a, --suffix-length=N
use suffixes of length N (default 2)
-b, --bytes=SIZE
put SIZE bytes per output file
-C, --line-bytes=SIZE
put at most SIZE bytes of lines per output file
-l, --lines=NUMBER
put NUMBER lines per output file
--verbose
print a diagnostic to standard error just before each output file is opened
--help display this help and exit
--version
output version information and exit
SIZE may have a multiplier suffix: b for 512, k for 1K, m for 1 Meg.
AUTHOR
Written by Torbjorn Granlund and Richard M. Stallman.
REPORTING BUGS
Report bugs to <bug-coreutils@gnu.org>.
COPYRIGHT
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
LAR PURPOSE.
SEE ALSO
The full documentation for split is maintained as a Texinfo manual. If the info and split programs are properly installed at your site,
the command
info split
should give you access to the complete manual.
split (coreutils) 4.5.3 February 2003 SPLIT(1)