12-26-2011
@ida1215: Copy-paste that perl one-liner on your command line. It should work, unless you don't have perl installed. It'll give the same output as bash code, sans the first header line "x y values".
This User Gave Thanks to balajesuri For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have an input data file :-
Test4599,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,2,2,Rain
Test90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,Not Rain
etc....
I wanted to transpose these data to:-... (2 Replies)
Discussion started by: ahjiefreak
2 Replies
2. Shell Programming and Scripting
How do I access one of the indices in array tst with the code below?
tst=sprintf("%5.2f",Car / 12)
When I scan thru the array with
for ( i in tst ) { print i,tst }
I get the output of:
vec-7 144
But when I try this in the END
print tst
It looks like it's not set.
What am... (6 Replies)
Discussion started by: timj123
6 Replies
3. Shell Programming and Scripting
Hi,
I have this typical extraction problem in AWK.
I have 3 input files..
i) First one is somehow like an oracle of:-
foo 12,23,24
bla 11,34
car 35
ii)Second file is basically detailing the score for each of the second field of first file. Besides, for the first column, it is the... (3 Replies)
Discussion started by: ahjiefreak
3 Replies
4. Shell Programming and Scripting
Hi,
can I use array elements ( all ) in conditional statements?
the problem is ,the total number of elements is not known.
e.g
A is an array with elements - 1,2,3
now if i want to test if the 1 st field of input record is either 1,2 or 3, i can do something like this
if ( $1 ~... (1 Reply)
Discussion started by: shellwell
1 Replies
5. Shell Programming and Scripting
i have an array call ignore. it is set up
ignore=34th56
ignore=re45ty
ignore=rt45yu
.
.
ignore=rthg34
n is a variable. I have another variable that i read from a different file. It is $2 and it is working the way i expect. array ignore read and print correct values.
in the below if... (2 Replies)
Discussion started by: usustarr
2 Replies
6. Shell Programming and Scripting
i just want to dump my array and see if it contains the values i am expecting. It should print as follows,
ignore=345fht
ignore=rthfg56
.
.
.
ignore=49568g
Here is the code. Is this even possible to do? please help
termReport.pl < $4 | dos2ux | head -2000 | awk '
BEGIN... (0 Replies)
Discussion started by: usustarr
0 Replies
7. Shell Programming and Scripting
Hi,
I have file1 like this:
a 64
b 66
c 67and file2 like this:
@1234
1123
aabbcc
@5453
5543
ccbaI want to replace each letter of the third line in file2 with corresponding number in file1. So desired output is,
@1234
1123
646466666767
@5453
5543
67676664I tried something like... (4 Replies)
Discussion started by: polsum
4 Replies
8. Shell Programming and Scripting
Hi all,
I'm dealing with a bash script to merge the elements of a set of files and counting how many times each element is present. The last field is the file name.
Sample files:
head -5 *.tab==> 3J373_P15Ac1y2_01_LS.tab <==
chr1 1956362 1956362 G A hom ... (7 Replies)
Discussion started by: lsantome
7 Replies
9. Shell Programming and Scripting
I need your help to discover missing elements for each box.
In theory each box should have 4 items: ITEM01, ITEM02, ITEM08, and ITEM10.
Some boxes either have a missing item (BOX02 ITEM08) or might have da duplicate item (BOX03 ITEM02) and missing another one (BOX03 ITEM01).
file01.txt
... (2 Replies)
Discussion started by: alex2005
2 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Sure it's an easy one, but it drives me insane.
input ("|" separated):
1|A,B,C,A
2|A,D,D
3|A,B,B
I would like to count the occurence of each capital letters in $2 across the entire file, knowing that duplicates in each record count as 1.
I am trying to get this output... (5 Replies)
Discussion started by: beca123456
5 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)