05-05-2010
How to delete already existing data in a file using perl? Pls help me!!
Dear Friends,
I need urgent help from u..
I have two files,file1 & file 2..
file1 have a existing data of file2.So i want to delete those existing datas from file1 (which contain the data from file1)
My file1 like this
rs39348 1 1045729 A G 0.1791 0.2054 0.84
rs37377 1 1061338 A G 0.2845 0.2809 1.01
rs66877 1 1070488 A G 0.1768 0.1956 0.88
rs96512 1 1071463 A G 0.2743 0.2689 1.02
rs49704 1 1088878 G A 0.0922 0.0757 1.24
rs12726 1 1089873 G A 0.1369 0.1231 1.13
rs22982 1 1104902 A G 0.1448 0.1542 0.928
My file2 have a data like
rs37377 1 1061338 A G 0.2845 0.2809 1.018
rs96512 1 1071463 A G 0.2743 0.2689 1.02
rs12726 1 1089873 G A 0.1369 0.1231 1.13
rs22982 1 1104902 A G 0.1448 0.1542 0.928
output should be like following format,
rs39348 1 1045729 A G 0.1791 0.2054 0.84
rs66877 1 1070488 A G 0.1768 0.1956 0.88
rs49704 1 1088878 G A 0.0922 0.0757 1.24
The output should contain non-existing data in a file2..
pls help me friends,,I need a program in perl or R language..I need very urgent
Thanks
Suresh
Last edited by sureshraj; 05-05-2010 at 05:32 AM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How can I delete a file from an existing Solaris tar file ? (not gtar) (2 Replies)
Discussion started by: avnerht
2 Replies
2. Shell Programming and Scripting
hi
i am having four files in a directory.like
1)sampleRej
2)exampleRej
3)samplemain
4)examplemain
my requirement is i have to search for the rejected files (sampleRej,exampleRej) in a directory.if these files in that directory then i have to delete the main files... (3 Replies)
Discussion started by: srivsn
3 Replies
3. Shell Programming and Scripting
not required this time (36 Replies)
Discussion started by: Sandeep_Malik
36 Replies
4. UNIX for Dummies Questions & Answers
i have a file called motors with 3 columns separated with tabs eg:
car make reg
i want to create a executable file that will add a line with data eg:
car make reg
benz s600 t35778
can you please show me how to do this? (7 Replies)
Discussion started by: fletcher
7 Replies
5. Shell Programming and Scripting
Hi all,
I need help to add additional data from file2 to existing data in file 1 using awk, sed or perl. the ID in file 1 should match against field $3 in file2
file1
#this is a new game
ID HR_1
BASE1 30
BASE2 37
DETAIL No
TYPE L
@@
ID HR_10
BASE1 6030
BASE2 ... (4 Replies)
Discussion started by: redse171
4 Replies
6. Ubuntu
Hi All
I need to add a column on my existing data file. I know similar posts are there but none of them were meeting my requirement. My input is
1.20 3.44 4.88
5.11 4.99 3.22
1.89 3.89 2.90
Desired output
1 1.20 3.44 4.88
2 5.11 4.99 3.22
3 1.89 3.89 2.90
I will... (2 Replies)
Discussion started by: mahbub03
2 Replies
7. Shell Programming and Scripting
Hi,
I have a data file with :
01/28/2012,1,1,98995
01/28/2012,1,2,7195
01/29/2012,1,1,98995
01/29/2012,1,2,7195
01/30/2012,1,1,98896
01/30/2012,1,2,7083
01/31/2012,1,1,98896
01/31/2012,1,2,7083
02/01/2012,1,1,98896
02/01/2012,1,2,7083
02/02/2012,1,1,98899
02/02/2012,1,2,7083
I... (1 Reply)
Discussion started by: himanish
1 Replies
8. Shell Programming and Scripting
Hello All,
I have the following code in PERL to write data to excel sheet.
Can someone please help me about how to append data to an exisitng cell?
For ex in the below given case,Cell 1,1 has Active State PERL
Now I want to add a new line like "prorgamming" without overwritting the... (3 Replies)
Discussion started by: prasperl
3 Replies
9. Shell Programming and Scripting
Hi, I was wondering if someone would be able to help with extrapolating information from a file and filling an existing matrix with that information.
I have made a matrix like this (file 1):
A B C D
1
2
3
4
I have another file with data like this (file 2):
1 A
1 C
3 C
4 B... (1 Reply)
Discussion started by: hubleo
1 Replies
10. Shell Programming and Scripting
Input File 1
cat S1.txt
MI0043 2731 miR-1
Input File 2
cat S4.txt
MI006 310 CiR-1
MI057 10 CiR-24
MI750 5 CiR-24
Desired Output File 1
cat S1.txt.out
MI0043 2731 miR-1 S1.txt
Desired Output File 2
cat S4.txt.out
MI006 310 CiR-1 S4.txt (3 Replies)
Discussion started by: perl_beginner
3 Replies
XZDIFF(1) XZ Utils XZDIFF(1)
NAME
xzcmp, xzdiff, lzcmp, lzdiff - compare compressed files
SYNOPSIS
xzcmp [cmp_options] file1 [file2]
xzdiff [diff_options] file1 [file2]
lzcmp [cmp_options] file1 [file2]
lzdiff [diff_options] file1 [file2]
DESCRIPTION
xzcmp and xdiff invoke cmp(1) or diff(1) on files compressed with xz(1), lzma(1), gzip(1), or bzip2(1). All options specified are passed
directly to cmp or diff. If only one file is specified, then the files compared are file1 (which must have a suffix of a supported com-
pression format) and file1 from which the compression format suffix has been stripped. If two files are specified, then they are uncom-
pressed if necessary and fed to cmp(1) or diff(1). The exit status from cmp or diff is preserved.
The names lzcmp and lzdiff are provided for backward compatibility with LZMA Utils.
SEE ALSO
cmp(1), diff(1), xz(1), gzip(1), bzip2(1), zdiff(1)
BUGS
Messages from the cmp(1) or diff(1) programs refer to temporary filenames instead of those specified.
Tukaani 2009-07-05 XZDIFF(1)