Search Results

Search: Posts Made By: siya@
1,199
Posted By siya@
So I used this to find the entries: select...
So I used this to find the entries:

select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1;

But how should I update them?

...
1,199
Posted By siya@
UPDATE COmmand post comparing 2 columns in 2 mysql tables
my queryis :

select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1;
[/CODE]But how should I update them?

i used update...
2,556
Posted By siya@
Replace all decimal values in a column
Hi
My input file looks

String000002 GeneWise CW 48945 49354 . - 0 Pt=PEQU_00004;
String000002 LEN NA 52125 52604 0.945751 - . ...
1,076
Posted By siya@
SQL compare database
Hi ,

I have 2 databases which has same table names and I need to list entries of a particular table in database1 not existing in the same tablename of database2.


eg : I have db1 having...
1,022
Posted By siya@
This is the code I tried! Sorted the file first...
This is the code I tried!
Sorted the file first and then tried to join the contents!

sort -o file
join f4a f4b | whille read f4a f4b
do
if (( ( $f4a <= $f4a'next)
||( $f4b <= $f4b'next) ))...
1,022
Posted By siya@
Edit locations in a file
Hi ,
I have a file which looks like this

source1 LEN predictive 392879 394347 0.955489 + . Name=sa000003.1;ID=sa000003;Alias=sa121751.1;
source1 LEN ...
1,078
Posted By siya@
Sorting Python
i have written a code to get the following result but i think am missing something


def insert_switch(list):
for i in range(len(list)-1,0) :
value =list[i]
for j in...
Forum: Programming 08-16-2013
12,076
Posted By siya@
Concatenate string from text file
Hi

mY files paths are defined as :


//sbase = 'D:\data\sample_AMC\fasta_files\';
sbase2 = 'D:\data\sample_AMC\fasta_files\results\';
snameprefix = 'orig_ind';
snameprefix3 = 'results_ind';...
Forum: Programming 07-16-2013
2,875
Posted By siya@
Save output in text C++
Hi ,
i want to save the output of my c ++ code to a text file which is in a particular path :
this is part of my code and I dunno where I am doing it wrong


do
{
for( int i =...
Forum: Programming 07-14-2013
1,128
Posted By siya@
Looping and caling in a text file C++
Hi ,

I am trying to create a loop to call in the entries from the text file named Set.
The entries of Set.txtare :
1 2 3
2 4 5
and so on .. (64 such combinations)

it basically means the...
Forum: Programming 05-07-2013
1,454
Posted By siya@
thanks a ton!!:)
thanks a ton!!:)
Forum: Programming 05-07-2013
1,454
Posted By siya@
Sql select replace
Hi All,

I had a query related to sql select replace command.
i have a table named clusters and it looks like this


Code:
name characteristics...
2,965
Posted By siya@
Thanks for the suggestions. I could figure out my...
Thanks for the suggestions. I could figure out my solution though.
2,965
Posted By siya@
Hi, Sorry for the confusion!! I want to...
Hi,
Sorry for the confusion!!

I want to basically convert ONLY the first column of my entire sequence
from

PH01000000G0240 to string0G0240...
2,965
Posted By siya@
my required result is string0G0240...
my required result is
string0G0240 P.he_genemodel_v1.0 CDS 120721 121773 . - . ID=PH01000000G0240.CDS;Parent=PH01000000G0240
string1G0190 P.he_genemodel_v1.0 mRA 136867 137309 . - ....
2,965
Posted By siya@
Split command
Hi I have a sequence which looks like this
# PH01000000
PH01000000G0240 P.he_genemodel_v1.0 CDS 120721 121773 . - . ID=PH01000000G0240.CDS;Parent=PH01000000G0240
PH01000001G0190...
1,199
Posted By siya@
Replace command
Hi ,

I have a sequence which looks like this

Lsat01000001
Lsat01000002
Lsat01000003
..
Lsat01000999
..
Lsat01100001
Lsat01278544

i want my output to look like this:

seq1
seq2...
2,374
Posted By siya@
Is there any other method for doing the same?
Is there any other method for doing the same?
2,374
Posted By siya@
Is there a way I could attach my file on this . ...
Is there a way I could attach my file on this .
Coz i couldnt resolve the issue

:confused::confused:
2,374
Posted By siya@
i am getting error... This is brief...
i am getting error...

This is brief desciption of what i did
original file
sat_1_g3_g_0_8540 . FFF 1 15501 . . . ...
2,374
Posted By siya@
Just an addition to this post if my sequence...
Just an addition to this post
if my sequence looks like this

string_8540 . FFF 1 15501 . . . ID=sat_1_g3_g_0_8540

string_8510 . FFF ...
2,374
Posted By siya@
what does the 2 indicate in the above mentioned...
what does the 2 indicate in the above mentioned code?

sed 's/^sat_1_g3_g_[02]/string/' infile >sortedfile
2,374
Posted By siya@
Selective replace
i have a large sequence of format

sat_1_g3_g_0_8540 . A 1 15501 . . . ID=sat_1_g3_g_0_8540;parentName=sat_1_g3_g_0_8540;Al=sat_1_g2_g_0_8540;...
1,335
Posted By siya@
GREP for sorting
Hi ,

I have a file which has a large number of sequences of type:


gi_1
AASSKSKSKSSKSKSK....
series_121
DDKFKFKGKGKH
gi_3
FFFFLFFLFLFLF
series_1
DFFFFFF
pattern_3
GEEEEEEEEE
gi_2...
2,800
Posted By siya@
It worked!! :):b: ---------- Post updated at...
It worked!! :):b:

---------- Post updated at 02:55 PM ---------- Previous update was at 02:54 PM ----------

Thanks very much!! It worked!!!
Showing results 1 to 25 of 26

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