topic Re: Textbetween challenge in App Development

Textbetween challenge

marcel_olmo — Sat, 16 Nov 2024 21:40:43 GMT

Hi guys,

I have to read some information inside two tags like the following :

<div id="main" class="class 1"> 10 </div>

If I do this :

TextBetween(MyField, '<div id="main" class="content 1">', '</div>')

I'll get my desired result, which is 10.

But sometimes the content of class is class 1, sometimes is class 2, or 3.

But, if I try this to include all the possibilities :

TextBetween(MyField, '<div id="main" class="content *">', '</div>')

it doesn't recognize the '*' to get a regular expression.

How could I do this?

Regards, Marcel.

Re: Textbetween challenge

sunny_talwar — Sat, 29 Dec 2018 23:02:14 GMT

How about doing just this

TextBetween(MyField, '">', '</div>')

Re: Textbetween challenge

petter — Sun, 30 Dec 2018 09:15:50 GMT

You mention regular expression - and Qlik doesn't support regular expressions ... although it supports wildcards in various contexts but not in the TextBetween() function.

TextBetween doesn't recognized tags at all just pure text so how about trying this expression:

TextBetween( TextBetween( Field , '<div id="main" class="content ', '/div>') , '>' , '<' )

Re: Textbetween challenge

petter — Sun, 30 Dec 2018 09:27:03 GMT

This should be even more exact:

TextBetween(
Replace(Replace(Replace( MyField
, 'class="content 1"' , '§' )
, 'class="content 2"' , '§')
, 'class="content 3"' , '§'
)
,'<div id="main" §>', '</div>'
)

Or slightly less readable:

TextBetween(Replace(Replace(Replace( MyField,'class="content 1"','§'),'class="content 2"','§'),'class="content 3"','§'),'<div id="main" §>','</div>')

Re: Textbetween challenge

marcel_olmo — Tue, 08 Jan 2019 17:28:27 GMT

Thanks Peter! I've used your solution to make a workaround for my issue.

Regards, Marcel.