topic string function in QlikView

string function

QSense — Fri, 05 Jul 2013 12:27:38 GMT

Hello everybody;

Ihave a case in that there is one slash in value but the other value has 2 slashes

I want get red lined values

Both of them have same properties such as

From right side , ıt starts from first slash and it goes until @IPASS value

I tried to get value with textbetween function like

TextBetween(USERNAME,'/','@IPASS',2)

but it start from left side.

Thank you

MayilVahanan — Fri, 05 Jul 2013 12:37:09 GMT

Try like this

=TextBetween('IPASS/0U2hdL90f7/setudsh@alfalavalsmart@IPASS','/','@IPASS',SubStringCount('IPASS/0U2hdL90f7/setudsh@alfalavalsmart@IPASS','/'))

=TextBetween(UserName,'/','@IPASS',SubStringCount(UserName,'/'))

hope it helps

flipside — Fri, 05 Jul 2013 12:37:13 GMT

Hi,

There are a few solutions to this - you could use one of the others posted on the other thread, or use something like this ...

=Subfield(TextBetween('IPASS/0U2kkSH00S/zhangchen.zhang@hcn@IPASS','/','@IPASS',1),'/',-1)

flipside

Fri, 05 Jul 2013 12:43:55 GMT

Hi people!

You should try the function e.g

subfield(USERNAME, '/' ,1)

And to remove the @IPASS you should use the function

replace(USERNAME,'@IPASS','')

subfield(replace(USERNAME,'@IPASS',''),'/',1)

Fri, 05 Jul 2013 12:48:22 GMT

Hi,

use below one

= SubField( TextBetween ( USERNAME ,'/','@IPASS',1),'/',-1)

Niranjan M.

Fri, 05 Jul 2013 12:54:38 GMT

use below one. u will get require answer

=mid($(a),index($(a),'/',-1)+1,(index($(a),'@',-1)-1)-(index($(a),'/',-1)))