Logic needed for substring

[#1]

Dear All,

I have a scenario to get the word beween particular characters.

ex: community\qlik\demo.com

I need to retrieve "demo" from the above string.    How i can achieve this??

Thanks in advance

[#2]

In brief .., i need the word after last occurance of '\' [slash]

[Anonymous]

=subfield(subfield(String, '\' ,-1),'.',1)

[giakoum]

use index to find the position of \ and .

and then mid to retrieve the string

[rubenmarin1]

Hi Praful, you can get that with:

=Subfield(SubField(TextField, '\', -1), '.', 1)

[rubenmarin1]

Or

=Left(SubField(TextField, '\', -1), Index(SubField(TextField, '\', -1), '.', -1)-1)

Will return the text between the last '\' and the last '.'. If the last word has a dot before the last .xxx it will the the entire word, ie:

community\qlik\eu.demo.com --> returns eu.demo

=Subfield(SubField(TextField, '\', -1), '.', 1) will return only 'eu'

[robert_mika]

=TextBetween('community\qlik\demo.com','\','.',2)

[#8]

Hi There,

To really keep it dynamic I would use the following:

=TextBetween('community\qlik\demo.com','\','.',SubStringCount('community\qlik\demo.com','\'))

Hope it helps.