Text filter data in the load script ? (where text contains...) Help!!!!

[bouderbc]

Text filter data  in the load script  ? (where text contains...)

usually  i use where but in my case it doesn't work properly because i have different types of character string ( Alpha numeric character, text character ) and they aren't always the same , please see the example below and File Attached :

When i want to filter on security with where , he did the job but he loads also other parts of the file , so is not efficient

please if u know this case , give me your solutions !

Name of the column: Title

Needs: Filter only where the field contains 'security'

[swuehl]

Maybe

LOAD Title

FROM ....

WHERE Wildmatch(Title,'*Security*');

[surendraj]

Load Title from sheet.xls

where wildmatch(title,'* security*');

[bouderbc]

Hi Stephan,

Thanx for your answer , i have already use it , it doesn't work properly , so i use a flag as a filter  :

if(WildMatch(Title,'*Security*'),'True','False') as Flag ,

i can filter now on my Data ,  but Now i want to use this flag in the load script, is it possible ?

[swuehl]

Can you upload a sample QVW with some sample data that demonstrates where the WHERE clause does not work properly?

[bouderbc]

Stephan , sorry  i can't share my Data , but i put an excel sample.

Thanx a lot

[thedatabee]

Hi Swuehl, can you please explain where should I put the where clause? 

I have given the col the name 'head'. 

LOAD head

FROM
[C:\Users\Kaunteya Shaw\Downloads\sheet.xls]

(biff, embedded labels, table is Sheet1$);