topic String function in QlikView

String function

QSense — Thu, 04 Jul 2013 13:48:49 GMT

Hi everybody,

I am not able to do a case about string function

My string is like this

IPASS/0U2kkSH00S/zhangchen.zhang@hcn@IPASS

In my case there is "IPASS" value in the begining and at the end of value I want to remove them and After second slash (red characters) I want to get this part

of value

How can I achieve

I tried with replace and match function but couldnt succeed

Thanks for replies

Re: String function

Thu, 04 Jul 2013 13:59:11 GMT

Hi,

Try this

=SubField(SubField('IPASS/0U2kkSH00S/zhangchen.zhang@hcn@IPASS','/',3),'@',1)&'@'&SubField(SubField('IPASS/0U2kkSH00S/zhangchen.zhang@hcn@IPASS','/',3),'@',2)

There may more efficient way..:)

Regards,

Amay

Re: String function

alexandros17 — Thu, 04 Jul 2013 14:05:27 GMT

let

Step1 = Replace('IPASS/0U2kkSH00S/zhangchen.zhang@hcn@IPASS', 'IPASS', '');

let Step2 = mid(Step1,Index(Step1,'/',2)+1);

let Step3 = mid(Step2,1, len(Step2)-1);

Re: String function

flipside — Thu, 04 Jul 2013 14:18:34 GMT

You can do this with 1 command ...

=TextBetween('IPASS/0U2kkSH00S/zhangchen.zhang@hcn@IPASS','/','@IPASS',2)

... this returns the text between the 2nd instance of '/' and the 1st instance of '@IPASS' that follows.

flipside