hi everybody:
My question is how could i add a new columns to a file that it has one column like this:
06/06/2005
06/07/2005
06/08/2005
06/09/2005
06/10/2005
06/11/2005
06/12/2005
06/13/2005
06/14/2005
06/15/2005
06/16/2005
06/17/2005
....
And i want add columns like :
06/06/2005 ... (4 Replies)
I have a file like this:
running:running since Mon Mar 3 09:46:19 2008:
running:running since Thu Mar 6 22:36:51 2008:
running:running since Tue Dec 4 00:34:15 2007:
running:running since Tue Dec 4 00:34:16 2007:
running:running since Mon Jan 21 11:15:04 2008:
running:running since... (3 Replies)
Hey,
Im trying to format the last command to tell me just the user names, logins, and the time that they were logged in. So far I got the users logins using a loop that counts the amount of times a user logged in but im not sure how to start the time array. The time im trying to use is the last... (2 Replies)
Srr for being pain her
let say i have a data in a file like this
1@1000
2@2000
4@4000
5@7770
6@8998
7@80008
i am a newbie in Unix
i need to add a comma to integer using AWK function. for example, 1,000 or 80,008
how can i do that
ps. i'm using bash shell (1 Reply)
echo "0.1 2.0 0.4 2.0 4.3 1.0 6.0 9.0" | awk 'BEGIN {total=0} {total += $1} END {print total}'
I want to add the above output from the echo command, but i can't figure this out. The output above always spits out inaccurate numbers.
can someone please provide me with a one liner similar to... (4 Replies)
I have the following awk one-liners:
awk '{if ($2==1) print 1, $1}' infile | awk '{sum+=$2}END{print 1, sum/NR}' > infile2
:
:
awk '{if ($2==n) print 1, $1}' infile | awk '{sum+=$2}END{print n, sum/NR}' > infile2
How to add a loop for instance from n=1 to n=100 in order to compact... (9 Replies)
Hello,
There was a nice article here located on this forum, but I have not posted enough to add that URL.
That touched up on how to do this, but I still have not been able to figure it out. The thread is closed.
I have a file that looks like:
02/16/2011,15:23,0:00:06,4455,8883332222... (5 Replies)
Hi experts
I have lots of test.sh, each test.sh has the dotest1() function, I want to add below code before dotest1() if the runtest.sh don't contains "getopts", can someone show me the way
while getopts "s" arg
do
case $arg in
s)
echo "ss"
... (2 Replies)
Hi all. Wondering if someone can help with an awk solution to a problem I'm stumped with.
I have a matrix file with >1000 fields and would like to add another column after each column with a text label. For example:
Input:
$cat file.txt
name col1 col2 col3 coln
aaaa ... (2 Replies)
I am trying to use awk to add a space in a string of text. My awk is close but does not produce the desured output. Thank you :).
input
washington aveLansing, MI
washington streetLansing, MI
Desired output
washington ave Lansing, MI
washington street Lansing, MI
awk -F"\t"... (9 Replies)
Discussion started by: cmccabe
9 Replies
LEARN ABOUT SUSE
begin
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)