i run the latest code and it seems that it works for certain data only but i could see that it almost get to the expected output. i will continue working on this and see how it goes..Thanks so much CaKiWi for your big help :)
The samples for the actual input for 2 files and expected output as attached. i put them in a file as it is going to be a bit crowded to post directly here even though i already simplified them. Thankshttp://www.mediafire.com/?q3u0ijwa9ik2o6k
i tried the 2nd approach.. some of the existing data in file 2 are gone like the @@ symbol, the ID, START and DONE for certain ids. Not only that, i do have some info (comments) that i put in the file 2 before ID 1 and these comments gone too.
Hi CakiWi,
i tried with a small set of actual data with the same order of id and it seems that it only works for the fist id and ignore the rest like this:-
ID 1
START S216
DONE D125
No 250-305
No 144-146
@@
ID 2
START S325
DONE D340
@@
ID 7
START S587
DONE...
Hi CaKiWi,
thanks for your prompt response..
the id in my first file does not follow the same order as in my second file. i did try your code but nothing happens, probably because of the order of the id? as of now, i'm still trying to do it..
Hi,
i need help on adding additional data from file 1 to file 2 as follows:-
_file1_
No 250-305 Id 1
No 144-146 Id 1
No 189-190 Id 2
No 1904-1909 Id 2
No 1962-1968 Id 2
No 221-222 Id 7
No 248-251 Id 8
No 257-258 Id 8
_file2_
ID 1
START S216
DONE D125
@@
the output...
it's ok... i just found the solution.
i changed the column for svid and i removed the ';' symbol from my input file and it works great!!
Thanks so much for your kind help on this.. :)
it is too crowded to post it here..so, i uploaded the file to MediaFire. Not sure it works or not..thid is my first time doing it.. :phttp://www.mediafire.com/?ufj0l3p7gq0nuwr
hi,
yeah, i tried that one too and it gives me the correct result even though i put in some redundant values.But when i try to work on the actual data, it gave me the result in my 2nd post. Actual data has much more fields and there are a lot of redundant values and it is in general file format...
Hi CaKiwi,
thanks so much for your response..
i tried your codes but it gives me results like this:-
id 4 13976 14249
id 13976 13978
id 4 14306 15651
id 15649 15651
id 5 16111 16236
id 16111 16113
id 5 16367 16643
id 6 21204 22151
id 21204 21206
id 6 22217 22765
id 22763 22765
the...
Hi,
i've been trying to extract min and max values for the following data using awk script but failed. i keep on getting the same repeated results for both min and max and the results seems ridiculous.
I need to generate results based on Id. If column 4 is a '+', then the min value should be...
hi,
i have a file that contains ID, Name, Start, End, Circular and Function. I just need ID and Name. i use below script and it works.
#!/usr/bin/perl
open (MYFILE, '>scaffold_1.txt');
select (MYFILE);
open (FILE, 'scaffold_11.txt');
while (<FILE>)
{
chomp;
my @fields = split /\|/...
Hi,
i am very new to PERL. I need to find Min and Max values for different ID (4,5,6) in multiple rows. eg:
13976 14249 4
14306 14416 4
15094 15651 4
16111 16236 5
16367 16643 5
19092 19624 5
19683 20561 5
21204 22151 6
22217 22765 6
This data is in data.dat file. The result...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.