topic Re: Using Wildmatch() to extract Words in QlikView

Using Wildmatch() to extract Words

anuradhaa — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have sentences in my column called labels.

ex -

03/02/2016 dfdfd, dgfidgfid, cust_abc

03/02/2016 dfdfd, dgfidgfid, cust_art, gdeugd

I want to get the word "cust_*" and split it "_" and get the 2nd potion.

ex - cust_abc ---> abc

I'm using below sysntax

If(WildMatch(Lable, 'cust_'), SubField(Lable, 'cust_', 2),'aaa') as Customer

but it always gives 'aaa'

Thanks

Re: Using Wildmatch() to extract Words

Kushal_Chawda — Tue, 12 Apr 2016 06:46:52 GMT

try

If(WildMatch(lower(Lable), 'cust_*'), SubField(Lable, '_', 2),'aaa') as Customer

if( lower(Lable) like 'cust_*', SubField(Lable, '_', 2),'aaa') as Customer

Re: Using Wildmatch() to extract Words

rwunderlich — Tue, 12 Apr 2016 07:11:24 GMT

If(WildMatch(Lable, '*cust_*'), SubField(Lable, 'cust_', 2)) as Customer

-Rob

Re: Using Wildmatch() to extract Words

sunny_talwar — Tue, 12 Apr 2016 08:26:02 GMT

Not sure if you need everything after cust_ or just the three letters or if the stuff after cust_ is variable, but I used Rob's code and tried make minor modification to pick only left 3 letters. May be this is not what you want, but I thought I would still share

Table:

LOAD Lable,

If(WildMatch(Lable, '*cust_*'), SubField(Lable, 'cust_', 2)) as Customer_Rob,

If(WildMatch(Lable, '*cust_*'), Left(SubField(Lable, 'cust_', 2), 3)) as Customer_Sunny;

LOAD * Inline [

Lable

03/02/2016 dfdfd, dgfidgfid, cust_abc

03/02/2016 dfdfd, dgfidgfid, cust_art, gdeugd

] (delimiter is |);

Re: Using Wildmatch() to extract Words

swuehl — Tue, 12 Apr 2016 08:36:58 GMT

Or like this, with a customizables stop character:

Let vStop = chr(39)&','&chr(39); //comma denotes break

//Let vStop = Chr(39)&chr(39); //digest to the end of label

Table:

LOAD Lable,

TextBetween(Lable & $(vStop),'cust_',$(vStop)) as Customer_Stefan,

If(WildMatch(Lable, '*cust_*'), SubField(Lable, 'cust_', 2)) as Customer_Rob,

If(WildMatch(Lable, '*cust_*'), Left(SubField(Lable, 'cust_', 2), 3)) as Customer_Sunny;

LOAD * Inline [

Lable

03/02/2016 dfdfd, dgfidgfid, cust_abc

03/02/2016 dfdfd, dgfidgfid, cust_art, gdeugd

03/02/2016 dfdfd, dgfidgfid, nocust

] (delimiter is |);