List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:February 17 2010 6:40pm
Subject:RE: compare column value to anything in a list of values
View as plain text  
[snip]
IN('value1','value2') should work for exact matches, also works for
integer values.
[/snip]

IN will not open and read his CSV file...

[snip]
Is there a simple function or method to compare a value in a column to
one or more items in a comma separated list?
[/snip]

In order to do this you are going to use a programming language or
scripting language. For PHP you could put the values from the CSV list
in an array and the use IN to compare against that array.
Thread
compare column value to anything in a list of valuesBryan Cantwell17 Feb
RE: compare column value to anything in a list of valuesBryan Cantwell17 Feb
Re: compare column value to anything in a list of valuesWm Mussatto17 Feb
  • RE: compare column value to anything in a list of valuesJay Blanchard17 Feb
    • Re: compare column value to anything in a list of valuesBaron Schwartz19 Feb