Search Results

input

chr1 10 100
chr1 10 100
chr1 20 200


output

chr1 10 100 2
chr1 20 200 1

For every specific keys i.e. 1st and 4th columns (a1 and ABC_001144992) remove 1st and last value (bold ones - 87942437 and 87952030 ) and print remaining
input


a1 87942437 87943147 1E...

input1


a1 1 10 1E_gx007
a1 20 30 2E_gx007
a1 50 60 3E_gx007


input2


a1 8 10 J1 100 gx007
a1 20 22 J1 120 gx007
a1 6 10 J2 200 gx007
a1 52 54 J2 220 gx007
a1 28 30 J3 300 gx007...

Filter unique alphabets (bold) from input

Thanx


+SRR015270.1 HWI-B10_3_6069:2:1:653:875 length=32
SZZZZZZZZZZZZXZZZXZZZOECZZIZHUEM
+SRR015270.2 HWI-B10_3_6069:2:1:455:450 length=32...

output1

c1 78507634 78507663 1_G_X
c1 78508442 78508630 2_G_X
c1 78519259 78519438 3_G_X
c1 78520148 78520353 4_G_X
c1 78524144 78524319 5_G_X
c1 ...

There is no logic.
Yes progressive numbers should be fine like 1_G_X...2_G_X etc...

One more thing please Can I get output like this ( a small change after removing 1st (2nd column) 78507634and...

Rad first script doing the job perfectly

awk '{
n11 = split($11, t11, ",")
n12 = split($12, t12, ",")
for (i = 0; ++i < n11;) {
s12 = $2 + t12[i]
print $1, s12, s12 + t11[i]
}...

Now I modified the instructions.

@ rad: yes you are right the first mistake you identified is the error (confusion of 11th and 12 columns)

Thank you for correcting me

I will try to explain directly how the input and output looks like and the way to produce output

every line in output comes from columns 2 (78507634), 3(78534748) and 11(last but one), 12(last).
...

May be try some thing like this


awk 'BEGIN {FS="\t"}
{
for (i=1;i<=NF;i++)
{
arr[NR,i]=$i;
if(big <= NF)
big=NF;
}
}
END {
for(i=1;i<=big;i++)
{
...

Hi guys I'm using the following script to change input file format to another format. some where I'm getting the error. Could you please let me know if you find out?


cat input.txt|egrep -v...

Hi java programmers
I'm a newbee to the Java. Could please help me to set the path correctly. I'm getting the following error.


----jGRASP exec: javac -g C:\Documents and...

That make sense. Thanx alot for cooperation.:b:

Still the same error.
Anyways with out it (\)the script working great. Thank you.
Still I have not cleared the doubts about previous scripts(awk one liners). Whats wrong with the previous scripts?

NULL is beacuse for the value in input1 key has no referred values with in +/- 1000 range in input2.
It would be great if I have this small one

I'm getting following error.


$ awk -f...

Hi.Thanx for explaining array definition by using a,b and c. Very helpful. The result for your code ouput is as almost same as mine. The bold letters in desired output below I high lighted are...

Here is the detailed input file with explanation in output(bold)
input1

x1 10
x1 100
x2 1000
x2 10000
x3 989
x4 345
x10 8767736477736
xx 234
xy 387889999

...

The input1 contain keys in first column (x1,x2 and so on). second column contains values ranging from smaller to largest (1 to 10000000 and so on).Second input is also the same.

Logic is to find...

I sounded bit rude in the previous mail. My apologies. and Thanx for the code.
The code is giving me trouble when the size of the number increases.

example
input1

x1 115404863 hfffhf...

make a list based on the first column key and corresponding value (2nd column-bold) in input1 search values that less than or equal to 1000 (2nd column-bold)in the input2 of the same key along with...

@radoullov ##How could I give you bonus points. yesterday I have seen some one credited with bonus points for answering my post.
You been really helpful every time.
Mr.Vidya is already in Moderator...

haha.
Always I would try to go with or write precise answers for any problems I come across.
actually I tried solving the problem above for a while. But quiet didn't get it though managed with...

input

a 100 200 300
b 400 10


output

a 100
a 200
a 300
b 400
b 10


Thanx

Thanx. Really appreciate for your time

Is it possible to do this with awk command??

sort1.txt

a 10
b 20
sort2.txt

a
b
c
d
join command


join sort1.txt sort2.txt && join -v1 sort2.txt sort1.txt
output

a 10...