02-22-2009
Good, looks like you figured it out.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
U have a file
File 1
0.3 0.2 0.4 0.3 0.8 0.11 0.22
0.4 0.23 0.45 0.56 0.78 0.98
0.11 0.32 0.2 0.4 0.45 0.54
0.2 0.33 0.44 0.21 0.22 0.98
0.8 0.2 0.34 0.54 0.98 0.12
0.1 0.22 0.32 0.34 0.89 0.22
File 2
rows columns
3 1
2 3
4 2
5 ... (8 Replies)
Discussion started by: cdfd123
8 Replies
2. UNIX for Advanced & Expert Users
Hi,
I required to print all rows into columns(some comma separated or else) till a pattern match found. Using Solaris UNIX scripting
my input is like
abc
def
ghi
jkl
mno
END
pqr
stu
vwx
yz
123
END
...
... (7 Replies)
Discussion started by: vikash.rastogi
7 Replies
3. Shell Programming and Scripting
Hi
My pipe delimited .txt file contains rows with 10 columns.
Can anyone advise how I output to file only those rows with the letters ‘ci'
as the first 2 characters in the 3rd column ?
Many thanks (4 Replies)
Discussion started by: malts18
4 Replies
4. Shell Programming and Scripting
Hi All,
I have a huge (and its really huge!) matrix about 400GB in size (2 million rows by 1.5 million columns) . I am trying to optimize its space by creating a sparse representation of it.
Miniature version of the matrix looks like this (matrix.mtx):
3.4543 65.7876 54.564
2.12344... (4 Replies)
Discussion started by: shoaibjameel123
4 Replies
5. Shell Programming and Scripting
Hi all,
I want to read some specific rows & columns in the .xls file with my script to get the data to be manipulated. Now, I can read the .xls file correctly & i can go to the specific sheet that I want but i have a problem to specify the specific rows & columns. I mean, I want to get the info... (0 Replies)
Discussion started by: Yohannita
0 Replies
6. Shell Programming and Scripting
Hi All
I want to have a Perl script which convert columns to rows.
The Perl should should read the data from input file.
Suppose the input file is
7215484
date to date
173.3
A
1.50
2.23
8.45
10.14
2.00
4.50
2.50
31.32
7216154
month to month (3 Replies)
Discussion started by: parthmittal2007
3 Replies
7. Shell Programming and Scripting
- I have two files (File 1 and File 2) and the contents of the files are mentioned below.
- I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2.
- I tried to modify and use... (10 Replies)
Discussion started by: Santoshbn
10 Replies
8. Shell Programming and Scripting
Hallo,
I would need to extract only rows which has different value in the second and third column.
Thank you very much for any advices
Input:
A 0 0
B 0 1
C 1 1
D 1 3
Output
B 0 1
D 1 3 (4 Replies)
Discussion started by: kamcamonty
4 Replies
9. Shell Programming and Scripting
Hello, everyone
I am beginner for shell programming. I want to print all lines that have the same values in first two columns
data:
a b 1 2
a a 3 4
b b 5 6
a b 4 6
what I expected is :
a a 3 4
b b 5 6
but I searched for one hour in... (2 Replies)
Discussion started by: nengcheng
2 Replies
10. UNIX for Beginners Questions & Answers
I have a dateset like this:
Gly1 Gly2 2 1 0
Gly3 Gly4 3 4 5
Gly3 Gly5 1 3 2
Gly2 Gly1 3 6 2
Gly4 Gly3 2 2 1
Gly6 Gly4 4 2 1what I expected is:
Gly1 Gly2 2 1 0
Gly2 Gly1 3 6 2
Gly3 Gly4 3 4 5
Gly4 Gly3 2 2 1
A vs B, or B vs A are the same... (7 Replies)
Discussion started by: nengcheng
7 Replies
LEARN ABOUT REDHAT
update
UPDATE(7) SQL Commands UPDATE(7)
NAME
UPDATE - update rows of a table
SYNOPSIS
UPDATE [ ONLY ] table SET col = expression [, ...]
[ FROM fromlist ]
[ WHERE condition ]
INPUTS
table The name (optionally schema-qualified) of an existing table. If ONLY is specified, only that table is updated. If ONLY is not speci-
fied, the table and all its descendant tables (if any) are updated. * can be appended to the table name to indicate that descendant
tables are to be scanned, but in the current version, this is the default behavior. (In releases before 7.1, ONLY was the default
behavior.) The default can be altered by changing the SQL_INHERITANCE configuration option.
column The name of a column in table.
expression
A valid expression or value to assign to column.
fromlist
A PostgreSQL non-standard extension to allow columns from other tables to appear in the WHERE condition.
condition
Refer to the SELECT statement for a further description of the WHERE clause.
OUTPUTS
UPDATE #
Message returned if successful. The # means the number of rows updated. If # is 0 no rows are updated.
DESCRIPTION
UPDATE changes the values of the columns specified for all rows which satisfy condition. Only the columns to be modified need appear as
columns in the statement.
Array references use the same syntax found in SELECT [select(7)]. That is, either single array elements, a range of array elements or the
entire array may be replaced with a single query.
You must have write access to the table in order to modify it, as well as read access to any table whose values are mentioned in the WHERE
condition.
By default UPDATE will update tuples in the table specified and all its sub-tables. If you wish to only update the specific table men-
tioned, you should use the ONLY clause.
USAGE
Change word Drama with Dramatic on column kind:
UPDATE films
SET kind = 'Dramatic'
WHERE kind = 'Drama';
SELECT *
FROM films
WHERE kind = 'Dramatic' OR kind = 'Drama';
code | title | did | date_prod | kind | len
-------+---------------+-----+------------+----------+-------
BL101 | The Third Man | 101 | 1949-12-23 | Dramatic | 01:44
P_302 | Becket | 103 | 1964-02-03 | Dramatic | 02:28
M_401 | War and Peace | 104 | 1967-02-12 | Dramatic | 05:57
T_601 | Yojimbo | 106 | 1961-06-16 | Dramatic | 01:50
DA101 | Das Boot | 110 | 1981-11-11 | Dramatic | 02:29
COMPATIBILITY
SQL92
SQL92 defines a different syntax for the positioned UPDATE statement:
UPDATE table SET column = expression [, ...]
WHERE CURRENT OF cursor
where cursor identifies an open cursor.
SQL - Language Statements 2002-11-22 UPDATE(7)