04-27-2008
Yes, total is calculated above outside of the END statement:
total = $3 + $4 + $5
($3-$5 being fields showing logins for each of three months)
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
infile:
z y x
c b a
desired output:
x y z
a b c
I don't want to sort the lines into this:
a b c
x y z
nor this:
c b a
z y x
The number of fields per line and number of lines is indeterminate. The field separator is always a space.
Thanks for the use of your collective brains.... (11 Replies)
Discussion started by: H2OBoodle
11 Replies
2. UNIX for Dummies Questions & Answers
Hi all.
I have 2 files like this:
f1
A 10
B 80
C 9
f2
A 11
B 700
C 10
What I want is the concatenation of the two files sorted by name (alphabetically) and size (numerically), so the result should be like this:
F3 (cat f1 f2 sorted)
A 10
A 11
B 80
B 700 (2 Replies)
Discussion started by: mrodrig
2 Replies
3. Shell Programming and Scripting
Hi,
I have been trying to find someone with this similar problem but I was out of luck.
So I have a file that has two columns that look like this (for example):
10 20
40 50
45 60
90 130
So column 1 is start and column 2 is stop but what I want to do is find whats not represented... (4 Replies)
Discussion started by: phil_heath
4 Replies
4. Shell Programming and Scripting
Hey guys, I have a file that contains the following:
366 K
364 Q
12 UB
7 INC. P
4 Law
2 LAMB
2 High
1 QEG
1 OF
1 LC
1 B
As you can see, it's already sorted by numerical order, how do I sort it again, breaking the ties by using the alphabetical order of the second column, but... (2 Replies)
Discussion started by: Andrew9191
2 Replies
5. Shell Programming and Scripting
Greetings - I'm not necessarily new to bash scripting - I'm probably between beginner and intermediate, but I have something that I just cannot figure out after many attempts to find it. I have a file that is merely a list of many files, with their respective paths, and a branch path (ClearCase)... (5 Replies)
Discussion started by: 1cor29
5 Replies
6. Shell Programming and Scripting
I have an array
X = ( -100 -90 -80 -70 -60 -50 -40 30 40 50 60 70 80 90 100 )
I want to find the place where values change from negative to positive. (8 Replies)
Discussion started by: kristinu
8 Replies
7. UNIX for Dummies Questions & Answers
Hello all,
I have a list of file names in a text document where each file name consists of 4 letters and 3 numbers (for example MACR119). There are 48 file names in the document (they are not in alphabetical or numerical order). I would like to reorder the list of names so that the 48th name is... (3 Replies)
Discussion started by: MDeBiasse
3 Replies
8. Shell Programming and Scripting
Hello,
I have files in a directory with names like,
./f0/84.40_E1200_85.39_E1300_f0_r00_1300-ON-0.25_S7A_v4_47.19.1.out.txt
./f0/84.40_E1200_85.83_E1200_f0_r00_1200-ON-0.25_S7A_v4_47.19.1.out.txt
./f0/84.60_E1100_86.45_E1100_f0_r00_1100-ON-0.25_S7A_v4_47.19.1.out.txt... (5 Replies)
Discussion started by: LMHmedchem
5 Replies
9. Shell Programming and Scripting
I have a problem with my homework I need to create a shell script using #!bin/awk -f
the script will output the file in an alphabetical order only words and after the word is : after that a space then , then it will be numbered each character by which line its been for example
CB
92A
A... (1 Reply)
Discussion started by: collapse
1 Replies
10. UNIX for Dummies Questions & Answers
Hi.
I'm trying to sort a list of items in a file alphabetically but starting from the letter 'X'. For instance if I had the following file;
test.txt
Z
A
T
W
Y
B
S
X
I would like the output to look like;
X
Y (8 Replies)
Discussion started by: mmab
8 Replies
END(7) SQL Commands END(7)
NAME
END - commit the current transaction
SYNOPSIS
END [ WORK | TRANSACTION ]
DESCRIPTION
END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT [commit(7)].
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
NOTES
Use ROLLBACK [rollback(7)] to abort a transaction.
Issuing END when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To commit the current transaction and make all changes permanent:
END;
COMPATIBILITY
END is a PostgreSQL extension that provides functionality equivalent to COMMIT [commit(7)], which is specified in the SQL standard.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)]
SQL - Language Statements 2010-05-14 END(7)