topic Re: Search Characters in text in QlikView

Search Characters in text

gr_eldred — Tue, 26 Sep 2017 22:07:45 GMT

Good afternoon,

In the field Comments I need to search for the characters Name: and //

example:

Name: Laura Gil Mejia //, Extended Warranty.

I need to put a 1 if you find Name: and //. or a 0 if you can not find it.

Can you help me ?

swuehl — Tue, 26 Sep 2017 22:11:17 GMT

Maybe like

LOAD

Comments,

If(WildMatch(Comments, '*Name:*//*'),1,0) as Flag,

...

gr_eldred — Tue, 26 Sep 2017 22:42:22 GMT

I have a question I need to look for have these two characters Name: and // have some records where they only have //.

with this solution I look at the two characters or any of them?

swuehl — Tue, 26 Sep 2017 22:50:36 GMT

The Comments field value needs to show 'Name:' as well as '//', and '//' needs to follow 'Name:'.

gr_eldred — Wed, 27 Sep 2017 00:21:58 GMT

I have problems I identify the condition in true case but in false case I can not imagine it is because it does not find the words and sees a Null

jayanttibhe — Wed, 27 Sep 2017 00:30:10 GMT

Can you please provide the sample of TRUE and FALSE conditions with Sample Data and expected results?