topic Re: wildmatch in QlikView

wildmatch

Tue, 11 Aug 2015 09:23:32 GMT

Hello,

I have a text field in my data source and for some of the records, the text field starts with a '*'.

I want to load only those records.

Tried :

Wildmatch (Text,'*')

Wildmatch(Text, chr(042))

This is not working properly, any help ?

Thanks

lironbaram — Tue, 11 Aug 2015 09:25:13 GMT

you can try

left(Text,1) ='*'

sunny_talwar — Tue, 11 Aug 2015 09:25:26 GMT

May be try this:

WildMatch(Replace(Text, '*', '|'), '|*')

MayilVahanan — Tue, 11 Aug 2015 09:27:05 GMT

Try like this

If(Left(Text, 1) ='*', Text) as Text

Load * from datasource where Left(Text, 1) ='*';