03-27-2008
I worked great
awk 'BEGIN { n = 100} { if ($1!= prev) { n++ } prev = $1; print $1,$2,n }'
Thanks a lot
10 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
Hi,
I am using a remote storage service for backing up our data - we want to have a script run as part of a cron job which would do the backups from our local Linux machine to the service's Linux machine.
I want to use tar and ssh to do this (rather than mounting the disk and using cp) .... (5 Replies)
Discussion started by: same1290
5 Replies
2. Shell Programming and Scripting
I want to automate the process of generating RSA keys. I want to remotley login to a linux machine from a windows maching without having to enter a password. For this I need to generate the RSA key pair. but I want to do this procedure on alot of linux machines. For which I was looking to automate... (2 Replies)
Discussion started by: lassimanji
2 Replies
3. Shell Programming and Scripting
i have an xml tag. The value for the tag should be iterated through out the xml document.
eg:
<data><id><id><name>a</name><addr>aaa</addr><phnumb>3456</phnumb><state>ca</state><city>ny</city></data>... (6 Replies)
Discussion started by: Sgiri1
6 Replies
4. Shell Programming and Scripting
hi to all.
im a newbie in unix shell scripts. i want to make a simple unix shell script using the bash shell that asks a user to press any key after a series of commands, or an x if he wishes to exit. here's a sample script that i made:
#!/usr/bin/bash
pause(){
/usr/bin/echo "\t\t Press... (3 Replies)
Discussion started by: booghaw
3 Replies
5. Shell Programming and Scripting
Hi All,
I need a shell script which could insert a sequence number column inside a dat file(pipe delimited).
I have the dat file similar to the one as shown below..
|A|B|C||D|E
|F|G|H||I|J
|K|L|M||N|O
|P|Q|R||S|T
As shown above, the column 4 is currently blank and i need to insert sequence... (5 Replies)
Discussion started by: nithins007
5 Replies
6. Shell Programming and Scripting
Hi all,
I have a file like this
ID 3BP5L_HUMAN Reviewed; 393 AA.
AC Q7L8J4; Q96FI5; Q9BQH8; Q9C0E3;
DT 05-FEB-2008, integrated into UniProtKB/Swiss-Prot.
DT 05-JUL-2004, sequence version 1.
DT 05-SEP-2012, entry version 71.
FT COILED 59 140 ... (1 Reply)
Discussion started by: manigrover
1 Replies
7. UNIX for Dummies Questions & Answers
Hi,
What tool is used to generate public and private keys for SCP?
Do you have an example script that generates these keys, puts them in files and then another example script that references them from SCP?
Thanks, (9 Replies)
Discussion started by: Astrocloud
9 Replies
8. UNIX for Advanced & Expert Users
Hi All,
I have setup ssh keys for a user to transfer files without password between two hosts. But still the first time scp asks for confirmation and generates a key
Due to this our jobs are failing.
Is there a way I can avoid that first time key generation and confirmation also and automate... (3 Replies)
Discussion started by: baanprog
3 Replies
9. Shell Programming and Scripting
Hi,
I am using the nested for loops to generate the sequence ,
taking start and end sequence number input from test.txt
(sample content mentioned below).
Also , can I print the rest of columns as well with sequence number into the same file.
for i in `cat test.txt|cut -d"," -f7`
do ... (8 Replies)
Discussion started by: tushar.modgil
8 Replies
10. Shell Programming and Scripting
Hi All,
I have a file which has data like
a,b
c,d
e,f
g,h
And I need to insert a new column at the begining with sequence no( 1 to n)
1,a,b
2,c,d
3,e,f
4,g,h
Please let me know how to acheive this in unix (3 Replies)
Discussion started by: weknowd
3 Replies
LEARN ABOUT CENTOS
dblink_build_sql_insert
DBLINK_BUILD_SQL_INSERT(3) PostgreSQL 9.2.7 Documentation DBLINK_BUILD_SQL_INSERT(3)
NAME
dblink_build_sql_insert - builds an INSERT statement using a local tuple, replacing the primary key field values with alternative supplied
values
SYNOPSIS
dblink_build_sql_insert(text relname,
int2vector primary_key_attnums,
integer num_primary_key_atts,
text[] src_pk_att_vals_array,
text[] tgt_pk_att_vals_array) returns text
DESCRIPTION
dblink_build_sql_insert can be useful in doing selective replication of a local table to a remote database. It selects a row from the local
table based on primary key, and then builds a SQL INSERT command that will duplicate that row, but with the primary key values replaced by
the values in the last argument. (To make an exact copy of the row, just specify the same values for the last two arguments.)
ARGUMENTS
relname
Name of a local relation, for example foo or myschema.mytab. Include double quotes if the name is mixed-case or contains special
characters, for example "FooBar"; without quotes, the string will be folded to lower case.
primary_key_attnums
Attribute numbers (1-based) of the primary key fields, for example 1 2.
num_primary_key_atts
The number of primary key fields.
src_pk_att_vals_array
Values of the primary key fields to be used to look up the local tuple. Each field is represented in text form. An error is thrown if
there is no local row with these primary key values.
tgt_pk_att_vals_array
Values of the primary key fields to be placed in the resulting INSERT command. Each field is represented in text form.
RETURN VALUE
Returns the requested SQL statement as text.
NOTES
As of PostgreSQL 9.0, the attribute numbers in primary_key_attnums are interpreted as logical column numbers, corresponding to the column's
position in SELECT * FROM relname. Previous versions interpreted the numbers as physical column positions. There is a difference if any
column(s) to the left of the indicated column have been dropped during the lifetime of the table.
EXAMPLES
SELECT dblink_build_sql_insert('foo', '1 2', 2, '{"1", "a"}', '{"1", "b''a"}');
dblink_build_sql_insert
--------------------------------------------------
INSERT INTO foo(f1,f2,f3) VALUES('1','b''a','1')
(1 row)
PostgreSQL 9.2.7 2014-02-17 DBLINK_BUILD_SQL_INSERT(3)