Hi Rob comma is used to specify a list of filter values, which is then splitted on comma and then fed in as IN statement. Is it some kind of description filter where comma is a part of data ?
cheers syed On Tue, 2007-12-18 at 11:03 +0000, Dr Rob Free wrote: > Hi > > I'm having a problem with data that contains commas. > > When I make a filter option (qualifier '=' or 'like') with commas in it > (using MartEditor), and select it in MartView it appears as a 'SELECT.. > FROM.. WHERE IN' statement in the SQL log (separated by space). However, > I get the correct statement when I select an option with no commas in > from the same filter. > > The Perl and XML generated through the buttons also include the > individual IN items. > > From this, I assume that BioMart uses the presence of commas as a > signal to create an IN statement and split the string at each space. Is > there a work-around to stop this happening? > > Thanks for your help > > Rob -- ====================================== Syed Haider. EMBL-European Bioinformatics Institute Wellcome Trust Genome Campus, Hinxton, Cambridge CB10 1SD, UK. ======================================
