Search Results

Hi Scrutinizer,

It seems worked perfectly now :)
Let me manual checking it one by one now.

Thanks a lot and again.

---------- Post updated at 11:57 AM ---------- Previous update was at...

Hi Scrutinizer,

I run your awk command at terminal as below:

awk ' NR==FNR { R[$1,$2]=$3 next } FNR>1 { h=$1 len=length($2) print RS h for(i=2; i<=NF; i++) { s=x for(j=1; j<=len; j++) {...

Hi Scrutinizer,

Glad that it is clear now.
I think I facing Syntax error again :(

I try to add semicolon at your code Post@16.
I believe I might missing some semicolon when run your awk...

Hi Scrutinizer,

Might to know what confuse you now?
Thanks.

---------- Post updated at 10:04 AM ---------- Previous update was at 09:47 AM ----------

I just edited my Post#1.

Hope it no...

Hi Scrutinizer,

It is doesn't matter the line issue on File 1. I can be a line which all words together or I can split the long word into many different line with 100 record each line.

The main...

Hi Scrutinizer,

I just edited my Post#1.
Is that make the thing clear now?

Basically I still have 2 Input File now.
The data I shown in Post#1 just a first few record as the whole file is...

Thanks, Scrutinizer.

Might to know how to correct Syntax error issue again?
If I run it as a long awk command at terminal.
It will return Syntax error etc.

If I copy and paste the whole...

Thanks for reminding, RudiC.
Sorry for my mistake.

I just edit my Post 1.
Thanks a lot.

Many thanks for your help.

I split the long sequence into 100 word a line now.
Unfortunately the output file just return the header with the first 100 word record :(

Hi Scrutinizer,

Thanks again.
It worked perfectly with my sample sequence provided.
However I aware if I replace it with my real own data set.
It just print out the original File 1 :(

Would...

Hi Scrutinizer,

I try with your awk code. It seems to return "Syntax error" :(

awk: NR==FNR { R[$1,$2]=$3 next } FNR>1 { s=x for(i=1; i<=length($2); i++) s=s (($1,i) in R ? R[$1,i] :...

Hi,

It seems like no work :(
It return the header together with the length of the fasta file I believe.

awk 'NR==FNR {a[$1,$2]=$2; b[$1,$2]=$3; c[$1]=$1; next} /^>/ {w=$0; sub(".*> *", "", w)}...

Hi,

The fasta sequence is only a very long single line :)

---------- Post updated at 04:52 AM ---------- Previous update was at 04:47 AM ----------

Hi,

Sorry.
Mind to know why it will...

I have two input file.:

File 1 is a large reference sequence (A large Fasta sequence);

File 1 (is a file which first line is the header description and line other ">" is its corresponding word...

Input file:

data1 0.05
data2 1e-14
data1 1e-330
data2 1e-14
data5 2e-60
data5 2e-150
data1 4e-9

Desired output:

data2 1e-14
data1 1e-330
data2 1e-14
data5 2e-60
data5 2e-150

I...

Thanks, Cragun.
It worked perfect for my case :)

---------- Post updated at 12:57 AM ---------- Previous update was at 12:56 AM ----------

Thanks, Singh.
It worked fine for my case as well :)...

Input file:

pattern1 100 250 US
pattern2 50 3050 UK
pattern3 100 250 US
pattern1 70 1050 UK
pattern1 170 450 Mal
pattern2 40 750 UK
.
.

Desired Output...

Hi,

Do anybody know how to use awk to count the pattern at specific column?
Input file

M2A928K 419 ath-miR159a,gma-miR159a-3p,ptc-miR159a 60 miR235a
.
.

Output file

M2A928K 419...

Hi,

Input file 1 :

37170 37196 77 51
37174 37195 73 52
37174 37194 73 53

Desired Output file 1 :

37170 37196 77 51

Input file 2 :

37174 37195...

Thanks, it worked fine and perfect :)

---------- Post updated at 09:59 PM ---------- Previous update was at 09:39 AM ----------

Hi Subbeh,

I have one more question need your advice :
...

Hi,

Anybody know how to print out the record that shown smallest number among column 3 and column 4
Case 1 Input :

37170 37196 77 51
37174 37195 73 52
37174 37194 73 ...

Thanks RudiC.
It worked based on the input file.
Do you mind to explain what is the meaning of "sort -k1.4n" ?
I can't really understand it.

Thanks first :)

Hi anbu23,

I hope that second column is from smallest to largest while third column is largest to smallest.

Thanks ya :)

Input file:

ID_34 2E-69 2324
ID_1 0E0 3254
ID_1 0E0 5434
ID_5 0E0 436
ID_1 1E-14 2524
ID_1 5E-52 46437
ID_3 65E-20 45467
ID_1 0E0 6578
...
[code]
Desired output file:
[code]
ID_1 0E0...

Hi RudiC,

After I try your awk command, it able to shown underline of region interest through terminal.
However when I open those *.txt by Microsoft Excel or Notepad.
It shown some...