topic Re: Logic needed for substring in QlikView

Logic needed for substring

Thu, 12 Feb 2015 13:57:52 GMT

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

Thu, 12 Feb 2015 13:58:57 GMT

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

Anonymous — Thu, 12 Feb 2015 14:01:37 GMT

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

giakoum — Thu, 12 Feb 2015 14:01:45 GMT

use index to find the position of \ and .

and then mid to retrieve the string

rubenmarin — Thu, 12 Feb 2015 14:02:19 GMT

Hi Praful, you can get that with:

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

rubenmarin — Thu, 12 Feb 2015 14:07:30 GMT

=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 — Thu, 12 Feb 2015 14:11:09 GMT

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

Thu, 12 Feb 2015 14:19:13 GMT

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.