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
