Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
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.
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);
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:
Hi,
Thanks for your quick response.
Thanks,
Hareesh.
Hi,
Thanks for your quick response.
Thanks,
Hareesh.
i think Simply we can use
Textbetween(documentTitle(),'[',']') so it give result between square bracket.
@gunji Per Your Health wrote:
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.
sorry but i m not sure about that.