11-06-2001
ls -lt | awk 'NR>1 {print $2, $9}'
10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. Shell Programming and Scripting
Please help me with this ...
Input file
N_DC_Fabric_A,AU_SAP01,c050760169900000(*),50060169472007fc(*),50060160472007fc(*),
N_DC_Fabric_A,AU_SAP02,c050760169900004,50060169472007fc(*),50060160472007fc(*),
N_DC_Fabric_A,AU_SAP03,c050760169900004,50060169472007fc,50060160472007fc,
... (9 Replies)
Discussion started by: greycells
9 Replies
BEGIN(7) SQL Commands BEGIN(7)
NAME
BEGIN - start a transaction block
SYNOPSIS
BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ]
where transaction_mode is one of:
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY
DESCRIPTION
BEGIN initiates a transaction block, that is, all statements after a BEGIN command will be executed in a single transaction until an
explicit COMMIT [commit(7)] or ROLLBACK [rollback(7)] is given. By default (without BEGIN), PostgreSQL executes transactions in ``autocom-
mit'' mode, that is, each statement is executed in its own transaction and a commit is implicitly performed at the end of the statement (if
execution was successful, otherwise a rollback is done).
Statements are executed more quickly in a transaction block, because transaction start/commit requires significant CPU and disk activity.
Execution of multiple statements inside a transaction is also useful to ensure consistency when making several related changes: other ses-
sions will be unable to see the intermediate states wherein not all the related updates have been done.
If the isolation level or read/write mode is specified, the new transaction has those characteristics, as if SET TRANSACTION [set_transac-
tion(7)] was executed.
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
Refer to SET TRANSACTION [set_transaction(7)] for information on the meaning of the other parameters to this statement.
NOTES
START TRANSACTION [start_transaction(7)] has the same functionality as BEGIN.
Use COMMIT [commit(7)] or ROLLBACK [rollback(7)] to terminate a transaction block.
Issuing BEGIN when already inside a transaction block will provoke a warning message. The state of the transaction is not affected. To
nest transactions within a transaction block, use savepoints (see SAVEPOINT [savepoint(7)]).
For reasons of backwards compatibility, the commas between successive transaction_modes can be omitted.
EXAMPLES
To begin a transaction block:
BEGIN;
COMPATIBILITY
BEGIN is a PostgreSQL language extension. It is equivalent to the SQL-standard command START TRANSACTION [start_transaction(7)], whose ref-
erence page contains additional compatibility information.
Incidentally, the BEGIN key word is used for a different purpose in embedded SQL. You are advised to be careful about the transaction
semantics when porting database applications.
SEE ALSO
COMMIT [commit(7)], ROLLBACK [rollback(7)], START TRANSACTION [start_transaction(7)], SAVEPOINT [savepoint(7)]
SQL - Language Statements 2010-05-14 BEGIN(7)