11-12-2003
comparing text files
I am comparing text files where there are number of rows of numbers from window to unix box
Is there any way of checking lets say 4 document of text file
and seeing the difference only (or missing rows of numbers)
with simple commands with lets say a batch file
FROM ABSOULTE BEGINEER ON UNIX
SEJ
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi Guys,
How can I compare 2 text files and show the differences between the 2 files but have some of the text ignored?
Example
File1 File2
Thomas Thomass !1st name!
David Davidd !2nd name!
John John !3rd name!
So,... (1 Reply)
Discussion started by: jimmyflip
1 Replies
2. AIX
hi!
some looping problem here...
i have a 2-column text file
4835021 20060903FAL0132006
4835021 20060904FAL0132006
4835021 20060905FAL0132006
4835023 20060903FAL0132006
4835023 20061001HAL0132006
4835023 ... (3 Replies)
Discussion started by: d3ck_tm
3 Replies
3. Shell Programming and Scripting
Hi all,
I have got a problem while comparing 2 text files and the result should contains the unique values(Non repeatable).
For eg:
file1.txt
1
2
3
4
file2.txt
2
3
So after comaping the above 2 files I should get only 1 and 4 as the output. Pls help me out. (7 Replies)
Discussion started by: smarty86
7 Replies
4. Shell Programming and Scripting
Hi All,
I have two files of the following formats
file 1 - this is a big file
>AB_1 gi|229194403|ref|ZP_04321208.1| group II intron reverse transcriptase/maturase
gdfjafhlkhlnlklaklskckcfhhahgfahajfkkallalfafafa
>AB_2 gi|229194404|ref|ZP_04321209.1|
gfksjgfkjsfjslfslfslhf
>AB_3... (1 Reply)
Discussion started by: Lucky Ali
1 Replies
5. Shell Programming and Scripting
I have this 2 files:
k5login
sanwar@systems.nyfix.com
jjamnik@systems.nyfix.com
nisha@SYSTEMS.NYFIX.COM
rdpena@SYSTEMS.NYFIX.COM
service/backups-ora@SYSTEMS.NYFIX.COM
ivanr@SYSTEMS.NYFIX.COM
nasapova@SYSTEMS.NYFIX.COM
tpulay@SYSTEMS.NYFIX.COM
rsueno@SYSTEMS.NYFIX.COM... (11 Replies)
Discussion started by: linuxgeek
11 Replies
6. Shell Programming and Scripting
RHEL 5.4 (Korn shell)
I have two files
First file
$ cat myfile_1.txt
JOHN
KEITH
CHANG
JUDE
CHRISTINE
KRISHNA
AHMED
ULRICH
JESSICA-- Second file has 3 names missing (AHMED, ULRICH, JESSICA )
$ cat myfile_2.txt
JOHN
KEITH
CHANG
JUDE
CHRISTINE (4 Replies)
Discussion started by: John K
4 Replies
7. UNIX for Dummies Questions & Answers
Hey everybody,
I am new here and already a question to ask, I just recently started some bioinformatic work for my PhD so I am slowly learning
Anyway, here is my problem, I have two text files, one contains the complete data file with 43000 genes and their read counts for all my samples... (1 Reply)
Discussion started by: ant55
1 Replies
8. Shell Programming and Scripting
Hi All,
I have 2 files like below
vi f1
frog
elephant
rabit
zebra
dog
vi f2
rabit
dog
==============
Now i want to comapre two files and the result will be
frog (8 Replies)
Discussion started by: kumar85shiv
8 Replies
9. Shell Programming and Scripting
Hi
i have 2 files
file1.txt
XX,ZZ,XC,EE,RR,BB
XC,CF,FG,RG,GH,GH
File2.txt
DF,GH,MH,FR,FG,GH,NOTOK
XX,ZZ,XC,EE,RR,BB,OK
result
XX,ZZ,XC,EE,RR,BB OK
look for column1 , XX and if it matches in File2.txt , retrieve the 7 th field from File2 and print in 3 rd file , ... (9 Replies)
Discussion started by: Shyam_84
9 Replies
LEARN ABOUT CENTOS
dblink_build_sql_delete
DBLINK_BUILD_SQL_DELETE(3) PostgreSQL 9.2.7 Documentation DBLINK_BUILD_SQL_DELETE(3)
NAME
dblink_build_sql_delete - builds a DELETE statement using supplied values for primary key field values
SYNOPSIS
dblink_build_sql_delete(text relname,
int2vector primary_key_attnums,
integer num_primary_key_atts,
text[] tgt_pk_att_vals_array) returns text
DESCRIPTION
dblink_build_sql_delete can be useful in doing selective replication of a local table to a remote database. It builds a SQL DELETE command
that will delete the row with the given primary key values.
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.
tgt_pk_att_vals_array
Values of the primary key fields to be used in the resulting DELETE 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_delete('"MyFoo"', '1 2', 2, '{"1", "b"}');
dblink_build_sql_delete
---------------------------------------------
DELETE FROM "MyFoo" WHERE f1='1' AND f2='b'
(1 row)
PostgreSQL 9.2.7 2014-02-17 DBLINK_BUILD_SQL_DELETE(3)