How to fetch only those records which contain the required string?

[qlikviewforum]

If the column contains following records/values. How can we fetch only those records which contains TEST? for example, in below data set 2 records contain "TEST". So my question is how can i fetch only that and ignore rest of the records. Please help! It is little urgent

tfgty@erery@yktyik@ytyityi@yityi

tytyityi@dhrtrtu@TEST@rtrt@trurtu

tut@gttyty@gtjgvj@ttrurtu@tgrujrtu

[MayilVahanan]

HI

Try something like this

If(FindOneOf('tytyityi@dhrtrtu@TEST@rtrt@trurtu','Test'),'Test')

[PrashantSangle]

Hi,

Use

if(Wildmatch(Fieldname,'*TEST*'),Fieldname)

Regards

[maxgro]

where wildmatch(yourfield, '*TEST*')

[#5]

I am assuming delimiter used is symbol @ and also you are looking to match TEST (with case sensitivity) and ignoring records that may contain something as DETEST or TESTIMONIAL.

Load * from <your_table_name or file_name> where match (Field_Name,'@TEST@');

[manideep78]

Hi,

You can simply use where condition in the script.

Load

---------

---------

---------

where <Your_FieldName> like '*TEST*' ;

Hope this helps.

Regards,

Manideep

[deepakqlikview_123]

Try

where wildmatch(yourfieldname, '*TEST*')=0 at the end of load statement

[#8]

Hi Manideep. Just a question on LIKE. Does it exist in QV? I am sorry I have not seen it being used neither I could find it in QV Help. Though it is used in native SQL statements. Am I making a correct statement?

[qlikviewforum]

where wildmatch(yourfield, '*TEST*')

thanks all, above one looks good. We can use Index too.

[Colin-Albert]

There is no LIKE function in QlikView.

You can use the match functions - match , mixmatch, wildmatch

or index to get the equivalent of like.

e,g,    where index(field, 'TEST') > 0