Search Results

Trust me. It is not. :(

Based on input1 specific key (column1, 4 and 5) take the values (column 2 and 3) overlap with input2. And Specify names based on output.

input1

a1 100 200 E1 ABC
a1 300 400 ...

for every specific $1,$2 check the values ($2,$3) of their E ot I of input1 and overlap with input2.

Specify names based on output.
#######
if middle value is missing name them "SE"
if first...

divide input values into specified number (-100 or -200) according to the key (a1 or a2 ....)
For ex: if we give -100 in the command line it would create 100 number intervals (1-100, 100-200,...

thanx Frank

Add 35 to the 3rd col (12000) in input if it is "+" and it will be 12035 in output.

Some thing like

awk '{if ($3==+) print $2,$3,$3+35,$1 else print $2,$3-35,$3,$1}'


+ abc1 12000
- ...

yes. Thanx alot!

filter the ones (ex:>1279_17_27_F3) that have 50letters (ABABABACACACACACAADADADADABABABABAACACACACACACAACAC) in input. And others that are less than 50 have to be ignore and the ones with more than...

working fine. but so many symbols ha!

Thanx
Ruby

cX 165112562 165113966 27 96.7
cX 165142877 165143651 14 53.73
cX 165323227 165327550 180 55.96

awk -F '{printf ("%0.0f\n",$1,"\t",(($2+$3)/2)-500,"\t",(($2+$3)/2)+500,"\t",$4,"\t",$5)}' x=500 $1

Here is the script I'm using


awk '{print $1,"\t",(($2+$3)/2)-x,"\t",(($2+$3)/2)+x,"\t",$4,"\t",$5}' x=500 $1

I just want to make float numbers (red) like normal numbers (green)
output

cX ...

thanx. working great

Thanx. But It's working great.

It is rather simple. b/b is first similar letter pair for ID2 so it is 1 and d/d is second similar so it is 3. Dissimilar letter should be always 2 (b/c is 2).

I think you misunderstand my...

Print same letters as 1 or 3 (ex:a/a)and different letters as 2 (ex:a/b)
based on Name and subname

1st column indicates main names (ex: ID1 is one main name) and 2nd column indicates sub names...

Your script produce some thing like this

input


IndID ID1 ID2 ID3 ID4 ID5 ID6
a1 N/N a/a a/b a/b a/a b/b
a2 b/b b/b b/b b/b b/c b/d
a3 ...

FYI:
1st rule similar letter of key should be always 1 or 3 (a/a is 1 or 3 not 2)
2nd rule dissimilar letters of a key should be always 2 not 3
3rd rule second occurrence of dissimilar letters of...

working great. thanx for your time. really appreciated

But I'm getting this output instead of your posted output?


I_1 a1 a/a 1
I_1 a2 a/a 1
I_1 a3 a/b ?
I_1 a6 a/b ?
I_1 a8 a/a ?...

Don't hate me scrutinizer. I need a small update.
Consider 1st and 2nd columns as keys and 3rd column as their values.

The recent awk script here is turning all they keys with values ( similar...

input

IndID a1 a2 a3 a6 a8 a9
I_1 a/a a/a a/b a/b a/a b/b
I_2 b/b b/b b/b b/b b/c b/d
I_3 c/c c/c c/d c/e c/e c/e

...

Thank you Jean. Really appreciate your help.

instead of posting answers or suggestions dont' give trash answers to the new users.
If you don't want to answer do not answer.

its not home work dude!