Search Results

Search: Posts Made By: AAWT
1,165
Posted By AAWT
thanks, it works in excel, but not in text...
thanks, it works in excel,
but not in text file, it was second column,
Best Regards
1,165
Posted By AAWT
Yes it is an excel file, I was trying to do in...
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
1,165
Posted By AAWT
Sorting columns for specific values
Dear All,
i have a column with values in excel table:

ATGC22327-p66
ATGC15922-p239
ATGC12710-p21743567
ATGC08037-p186
ATGC07969-p173
ATGC07345-p48534...
1,610
Posted By AAWT
thanks Pamu, thanks RudiC, its also work fine, ...
thanks Pamu,
thanks RudiC, its also work fine,
yes, its exactly what I need,:b:
thanks a lot
Regards
1,610
Posted By AAWT
Hi Pamu, I gave this command in cygwin, ...
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
1,610
Posted By AAWT
Sorting rows to columns
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:
...
4,694
Posted By AAWT
I used following command awk 'NR==1{for...
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...
4,694
Posted By AAWT
Dear all, i am sorry, but the both commands...
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...
4,694
Posted By AAWT
How to delete columns with numbers in an excel file?
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....
1,165
Posted By AAWT
Urgent_need to delete 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
...
4,653
Posted By AAWT
Dear Ygemici, I sent you the whole set. ...
Dear Ygemici,

I sent you the whole set.
Please find in your email.
Regards
4,653
Posted By AAWT
Dear Ygemici, thanks a lot for your...
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...
4,653
Posted By AAWT
I am sorry,,,O.S abbreviate for?? I'll try to...
I am sorry,,,O.S abbreviate for??
I'll try to send you the input file.

Regards
4,653
Posted By AAWT
Hi Ygemici, It is still not giving me...
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,"_");...
4,653
Posted By AAWT
Actually I need three outputs 1:which have all...
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
...
4,653
Posted By AAWT
Hi Ygemici, I got still some problem, in...
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...
4,653
Posted By AAWT
Thanks a lot,, but its only giving me counts...
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
4,653
Posted By AAWT
I am sorry but it is not giving me required...
I am sorry but it is not giving me required result. now it is giving this sign
~ instead of A and C
4,653
Posted By AAWT
Hi Joeyg, its not possible to get new file...
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
4,653
Posted By AAWT
Complex data sorting in excel files or text files
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 ...
2,326
Posted By AAWT
;) oh I am getting the problem with these from...
;) 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...
2,326
Posted By AAWT
Export table of 50 columns
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...
1,616
Posted By AAWT
:b: yes exactly this i need, Thanks a lot ...
:b: yes exactly this i need,

Thanks a lot

Regards
1,616
Posted By AAWT
Thanks Scrutinizer, it did the summing up but...
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...
1,616
Posted By AAWT
Summing up rows data regarding 1st column
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 ...
Showing results 1 to 25 of 37

 
All times are GMT -4. The time now is 05:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy