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

[sushil353]

Try this:

if(keepchar(product,'sv')='sv',product)

HTH

Sushil

[sivarajs]

Try this

Load * from tab

Where SubStringCount(Product,'sv')<>0 ;

[#4]

hi

try this

pick(match(Product,'sv'),'sv') as Product

[#5]

use as below

=IF(WildMatch(Product,'SV*'),Product)

[Anonymous]

Hi sivaraj

Please Try this

If(WildMatch(product, '*sv*', product)

Regards

Revathy

[nilesh_gangurde]

Hi Chaganti,

Use he below mentiones script if you are doing it at load time:

If (Wildmatch(product,'*SV*'),product,null()) as product

if you are doing this at the Chart level then use this.

If (Wildmatch(product,'*SV*'),product)

-Nilesh

[er_mohit]

Might sure that both fields are in one table and comment the field Productand try this

if(Product name='sv',Product)as Product

Is You use both Product then it show message 'You must have one unique fields '

whatever it comes

Hope it helps

[jagan]

Hi,

Try using Like operator in where condition

TableName:

Load

     *

from DataSource

Where Product Like '*sv*' ;

Hope this helps you.

Regards,

Jagan.

[alexandros17]

if product is a dimension then

if(index(product,'sv') >0 , c1, null())  and check box null values

if product is an expresion you have to mix this with aggregation operation for example

sum(if(index(product,'sv') >0 , value, null()))

where value is the field you use in your expressions

Hope it helps