05-10-2013
Thanks for the quick response ... but i am getting this
N_DC_Fabric_A,AU_SAP01,c050760169900000(*),50060169472007fc(*),50060160472007fc(*),PARTIAL
N_DC_Fabric_A,AU_SAP02,c050760169900004,50060169472007fc(*),50060160472007fc(*),PARTIAL
N_DC_Fabric_A,AU_SAP03,c050760169900004,50060169472007fc,50060160472007fc,OFFLINE
The first line should be CONNECTED
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have the following error:
ls -lt | awk 'BEGIN NR > 1 { print $2, $9 }'
Syntax Error The source line is 1.
The error context is
BEGIN >>> NR <<< > 1 { print $2, $9 }
awk: 0602-500 Quitting The source line is 1.
What I want to do is ls a directory, skip the first... (3 Replies)
Discussion started by: lesstjm
3 Replies
2. Shell Programming and Scripting
Hello,
I have the following command that does 2 searches.
awk '{if ($0 ~ /STRING1/) {c++} }{if ( c == 2 ) {sub(/STRING1/,"NEWSTRING") } } { print }' FILE
How do I search up after the first search?
thanks (4 Replies)
Discussion started by: ctcuser
4 Replies
3. Shell Programming and Scripting
i have a little awk script that I use looks this:
awk '{if (FNR==1){print FILENAME; print $0}else print $0}' file1...file2....fi... > bundled.
i have completely forgotten how to unbundle this. I have tried several different approaches and still can not remember how to unbundle the file bundled.... (2 Replies)
Discussion started by: moxxx68
2 Replies
4. Shell Programming and Scripting
I am trying to read through a file, gather the states in that file and change it from an abbreviation to the ful text.
Can anyone provide some assistance.
Thanks!! (4 Replies)
Discussion started by: cnitadesigner
4 Replies
5. Shell Programming and Scripting
How I can rid of the following presentation du -sk /u*/oradata/TEST/*.dbf |awk '{print total+=$1} 1.28003e+06
4.35109e+06
4.36134e+06
4.4535e+06
5.47752e+06
5.48777e+06
7.52554e+06
7.73036e+06
9.06158e+06
:confused: thank you (3 Replies)
Discussion started by: zam
3 Replies
6. UNIX for Dummies Questions & Answers
Hi, in the following script, what does " a=$0} END " mean ?
do we need that ? Thanks
awk '{a=$0} END {for (i=NR; i>=1; i--) print a}' file (3 Replies)
Discussion started by: james94538
3 Replies
7. UNIX for Dummies Questions & Answers
Can anyone help with this this one liner:
nawk -v RS='' '$1=$1' InputFile
What I have in the file:
0.0013985457223116
-0.0002338180925628
0.0
0.0003709430584958
-0.0005763523138347
0.0
And the output I want:
0.0013985457223116 -0.0002338180925628 0.0
0.0003709430584958... (1 Reply)
Discussion started by: mookie123
1 Replies
8. UNIX for Dummies Questions & Answers
I have a script problem that I am not able to solve due my very limited understanding of unix/awk.
This is the contents of test.sh
awk '{print $1}'
From the prompt if I enter:
./test.sh Hello World
I would expect to see "Hello" but all I get is a blank line. Only then if I enter "Hello... (2 Replies)
Discussion started by: JasonHamm
2 Replies
9. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
im using ls -l | xargs | awk '{what ever files here}'
im trying to get something that looks like this... (7 Replies)
Discussion started by: rontopia
7 Replies
10. Shell Programming and Scripting
Hi Experts,
I am trying to get system output to capture inside awk , but not working:
Please advise if this is possible :
I am trying something like this but not working, the output is coming wrong:
echo "" | awk '{d=system ("date") ; print "Current date is:" , d }'
Thanks, (5 Replies)
Discussion started by: rveri
5 Replies
LEARN ABOUT DEBIAN
sql::translator::parser::postgresql
SQL::Translator::Parser::PostgreSQL(3pm) User Contributed Perl Documentation SQL::Translator::Parser::PostgreSQL(3pm)
NAME
SQL::Translator::Parser::PostgreSQL - parser for PostgreSQL
SYNOPSIS
use SQL::Translator;
use SQL::Translator::Parser::PostgreSQL;
my $translator = SQL::Translator->new;
$translator->parser("SQL::Translator::Parser::PostgreSQL");
DESCRIPTION
The grammar was started from the MySQL parsers. Here is the description from PostgreSQL:
Table: (http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-createtable.html)
CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
{ column_name data_type [ DEFAULT default_expr ]
[ column_constraint [, ... ] ]
| table_constraint } [, ... ]
)
[ INHERITS ( parent_table [, ... ] ) ]
[ WITH OIDS | WITHOUT OIDS ]
where column_constraint is:
[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | UNIQUE | PRIMARY KEY |
CHECK (expression) |
REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL ]
[ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ]
[ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
and table_constraint is:
[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) |
PRIMARY KEY ( column_name [, ... ] ) |
CHECK ( expression ) |
FOREIGN KEY ( column_name [, ... ] )
REFERENCES reftable [ ( refcolumn [, ... ] ) ]
[ MATCH FULL | MATCH PARTIAL ]
[ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ]
[ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
Index: (http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-createindex.html)
CREATE [ UNIQUE ] INDEX index_name ON table
[ USING acc_method ] ( column [ ops_name ] [, ...] )
[ WHERE predicate ]
CREATE [ UNIQUE ] INDEX index_name ON table
[ USING acc_method ] ( func_name( column [, ... ]) [ ops_name ] )
[ WHERE predicate ]
Alter table:
ALTER TABLE [ ONLY ] table [ * ]
ADD [ COLUMN ] column type [ column_constraint [ ... ] ]
ALTER TABLE [ ONLY ] table [ * ]
ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }
ALTER TABLE [ ONLY ] table [ * ]
ALTER [ COLUMN ] column SET STATISTICS integer
ALTER TABLE [ ONLY ] table [ * ]
RENAME [ COLUMN ] column TO newcolumn
ALTER TABLE table
RENAME TO new_table
ALTER TABLE table
ADD table_constraint_definition
ALTER TABLE [ ONLY ] table
DROP CONSTRAINT constraint { RESTRICT | CASCADE }
ALTER TABLE table
OWNER TO new_owner
View table:
CREATE [ OR REPLACE ] VIEW view [ ( column name list ) ] AS SELECT query
AUTHORS
Ken Y. Clark <kclark@cpan.org>, Allen Day <allenday@ucla.edu>.
SEE ALSO
perl(1), Parse::RecDescent.
perl v5.14.2 2012-05-01 SQL::Translator::Parser::PostgreSQL(3pm)