Value of the variable

[gunji]

Hi,

Can any one help me on the below query.

LET vValue= MID(DocumentTitle(),INDEX(DocumentTitle(),'[')+1,INDEX(DocumentTitle(),']')-INDEX(DocumentTitle(),'[')-1);

What will be the vale of the variable.

Thanks,

Hareesh.

[justISO]

Hi, this variable extracting string between brackets of your app name. So, for example, let say your app you are working on is called

app_name[potato]next_part

so with this variable you take app name with function DocumentTitle() and extracting everything between [], where index function is showing the places of []. So answer will be

potato

If in app name there are no brackets, answer will be empty.

[SunilChauhan]

I thing Below gives  string between [ and ]

MID(DocumentTitle(),INDEX(DocumentTitle(),'[')+1,INDEX(DocumentTitle(),']')

and INDEX(DocumentTitle(),'[')-1)  shows Number 

i thing there may be Error as we Cannot Subtract String  minus number

i Susspect correct should 

MID(DocumentTitle(),INDEX(DocumentTitle(),'[')+1,INDEX(DocumentTitle(),']')-1);

[justISO · Accepted solution]

Gunji formula works fine, and it is even more advanced as IamBack suggested, because it is shows string between [] even though there are more characters after that:

[gunji]

Hi,

Thanks for your quick response.

Thanks,

Hareesh.

[gunji]

Hi,

Thanks for your quick response.

Thanks,

Hareesh.

[SunilChauhan]

i think Simply we can use 

Textbetween(documentTitle(),'[',']')  so it give result between square bracket.