topic Re: extract string in QlikView

extract string

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

i have 2 field values

sales_mrtyf_qtr_09_2017

under_qtr_03_2015

i want to extract the string 'qtr' from both values. how to achieve that?

Re: extract string

tresB — Thu, 04 Oct 2018 10:31:16 GMT

It's 3rd subfield (delimited by '_') from end.

try like:

=SubField(YourField,'_', - 3 )

Re: extract string

sanjujeeboy — Thu, 04 Oct 2018 10:33:22 GMT

the end is not specific....after 2017 there can be values like 2017_abc etc..

Re: extract string

shwethaa — Thu, 04 Oct 2018 10:40:35 GMT

Try this-

=mid('sales_mrtyf_qtr_09_2017',index('sales_mrtyf_qtr_09_2017','qtr',1),3)

Mid(text,index(text,searchstring,1),3)

Re: extract string

arvind1494 — Thu, 04 Oct 2018 10:41:46 GMT

Try this

left(Right('sales_mrtyf_qtr_09_2017',11),3)

left(Right('under_qtr_03_2015',11),3)

Re: extract string

sunilkumarqv — Thu, 04 Oct 2018 10:52:43 GMT

This will work for

if(WildMatch(YourField,'*qtr*'),'Qtr')

Re: extract string

shwethaa — Thu, 04 Oct 2018 14:14:22 GMT

I don't think this solution will work because we can't predict that qtr will be in same position. So it is not flexible with different data right?

Re: extract string

raman_rastogi — Thu, 04 Oct 2018 15:11:26 GMT

Hi Jeeyboy

try this

replace(PurgeChar ( Replace('sales_mrtyf_qtr_09_2017','_qtr_','$'),

'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890'),'$','_qtr_')

Regards

Raman Rastogi

Re: extract string

vishsaggi — Thu, 04 Oct 2018 15:42:03 GMT

Try this?

= Mid(TextFieldnamehere, Index(YourTextFieldnamehere, 'qtr'), 3)

Re: extract string

sanjujeeboy — Thu, 04 Oct 2018 16:13:32 GMT

yes you are right.....the wildmatch solution given above is working fine.....

Re: extract string

sanjujeeboy — Thu, 04 Oct 2018 16:14:35 GMT

this solution is working .thanks

Re: extract string

sanjujeeboy — Thu, 04 Oct 2018 16:20:24 GMT

yes this is working...thanks

Re: extract string

sanjujeeboy — Thu, 04 Oct 2018 16:23:48 GMT

hey raman...

i found that wildmatch one more feasible....thanks