Search Results

thanks, it works in excel,
but not in text file, it was second column,
Best Regards

Yes it is an excel file, I was trying to do in excel by opening text file,
this is actually a tab delimited text file
Best Regards

Dear All,
i have a column with values in excel table:

ATGC22327-p66
ATGC15922-p239
ATGC12710-p21743567
ATGC08037-p186
ATGC07969-p173
ATGC07345-p48534...

thanks Pamu,
thanks RudiC, its also work fine,
yes, its exactly what I need,:b:
thanks a lot
Regards

Hi Pamu,
I gave this command in cygwin,
awk '{for(i=1;i<=length($2);i+=7){print $1,substr($2,i,7)}}'AT.txt > ATTT.txt

and got, SYNTEX ERROR line 1

waiting for help

Regards

Dear all,
I need your help to sort out a file with more then 15, 000 rows,

input file has following format :
AT4560 GO:1289GO:8915GO:9243GO:5739GO:6757GO:9245GO:9507output should be like:
...

I used following command

awk 'NR==1{for (i=1;i<=NF;i++) if ($i~/GType/) a[i]}{printf $1 FS; for (i=2;i<=NF;i++) if (i in a) printf $i FS;printf RS}' Data_Table.txt >Gtypes.txt

out put came...

Dear all,

i am sorry, but the both commands are not working for my file,
should I use them in Linux, as I tried in cygwin,
and Corona, yes I have this file in excel as well as in a tab delimited...

Dear all,
I have one file (see below) with more then 100 columns and 2500 rows, and need only column which has GType in label with Alphabets, please help me to remove these columns with numbers....

Dear all,
I have one file (see below) with more then 100 columns, and need only column which has GType in label with Alphabets, please help me to remove this columns with numbers.
input file is
...

Dear Ygemici,

I sent you the whole set.
Please find in your email.
Regards

Dear Ygemici,
thanks a lot for your effort,,,,,but there is still some problem
check line 4 and 5, that are not pairs ,,,these are still not giving the required output.

A_DY000990 C_JCVI_990...

I am sorry,,,O.S abbreviate for??
I'll try to send you the input file.

Regards

Hi Ygemici,

It is still not giving me desired output,
i don't know where is problem
# awk '/^A_/{a[$1]++;}/^C_/{c[$1]++}END{for(i in a){split(i,s,"_");for(j in c){split(j,ss,"_");...

Actually I need three outputs 1:which have all ids in pairs
A_ABCD_13208 C_ABCD_13208
A_QRST_9938 C_QRST_99382: with all unique C
C_EFGH_24808
C_ABC_15933. with all unique As
...

Hi Ygemici,

I got still some problem, in A_C_pairs, I am not getting the pairs of ids, I need to have same id only with A or C at start, but I am getting different As and Cs in file. ?????
As and...

Thanks a lot,,
but its only giving me counts like, 5432, 0r 2345

for A and C
is it possible to get new file with all A or C or A C pairs

Regards

I am sorry but it is not giving me required result. now it is giving this sign
~ instead of A and C

Hi Joeyg,

its not possible to get new file with A_ and C_ to be sure about pairs and unique.
this command give without A & C.

thanks

Dear all,
I have a complex data file shown below,,,,,


A_ABCD_13208 0 0 4.16735 141044 902449 1293900 168919
C_ABCD_13208 0 0 4.16735 141044 902449 1293900 ...

;) oh I am getting the problem with these
from google link,,,,,,

after opening in excel one row is coming in two rows,,,,,,,means last three columns data is in 2nd row,

and Brianjb,,,,
I...

Dear all,

I have a big table of 50 columns and more then 100, 000 rows in mysql. Could you please help me that how I can export it as .csv or . txt that I can open it in MS excel?????
OR how can...

:b: yes exactly this i need,

Thanks a lot

Regards

Thanks Scrutinizer,
it did the summing up but problem is, all the summing results are in the columns (Label; A; B; C ;D;E;F;G;H;I;J;K;L;M;N) its only in first column with all the readings.
its a...

Dear all,

I have one file like
LABEL A B C D E F G H I J K L M N
G02100 64651.3 25630.7 8225.21 51238 267324 268005 234001 52410.9 ...