String function

[QSense]

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

[#2]

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]

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 · Accepted solution]

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