how to search a strings in column ?

[#1]

     Hi team.

i have product column

now i want to display  only ( if product  name contain 'sv'  then  i want to

display only  that prducts)w

how to write  logic in script

thanks

[narender123]

Hi,

Try this.

in script level,

=If(product_name='sv',product_name)    // only include sv

or

=if(product_name='sv*',product_name)  //include sv + all char starting from sv..

Let me know if it would work..

Thanks.

[#3]

Hi,

You can use the function WILDMATCH.

LOAD *

FROM TABLE

WHERE Wildmatch(Product, '*sv*') >= 1;

Wildmatch will return 1 if the products contains sv and 0 if not.