Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

String function

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

1 Solution

Accepted Solutions
flipside
Partner - Specialist II
Partner - Specialist II

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

View solution in original post

3 Replies
Not applicable

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

alexandros17
Partner - Champion III
Partner - Champion III

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);

flipside
Partner - Specialist II
Partner - Specialist II

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