topic Re: Last Character for Text Between? in QlikView

Last Character for Text Between?

cbaqir — Wed, 20 Sep 2017 15:20:53 GMT

I am currently using the Stripping HTML Tags using Regular Expressions - 4GuysFromRolla.com VB script module to remove HTML tags from a field. I am then using TextBetween to break out the DESCRIPTION_CLEANED field to 5 separate fields. It works for the first 4 but for Voting Statement, I don't know what to do as the ending string because the data is being truncated and the Analytics string is sometimes not included. Similarly, for Analytics, I don't know what to put as the final string. Is there a function to pull last characters?

Select DEFECT_ID 8816 or 7474 as examples.

stripHTML(DESCRIPTION) as DESCRIPTION_CLEANED,
TextBetween( stripHTML(DESCRIPTION) , 'Current State Summary:' , 'Problem Statement:' ) as CUR_STATE_SUMMARY,
TextBetween( stripHTML(DESCRIPTION) , 'Problem Statement:' , 'Proposed Solution:' ) as PROBLEM_STATEMENT,
TextBetween( stripHTML(DESCRIPTION) , 'Proposed Solution:' , 'Voting Statement:' ) as PROP_SOLUTION,
TextBetween( stripHTML(DESCRIPTION) , 'Voting Statement:' , 'Analytics:' ) as VOTING_STATEMENT,
TextBetween( stripHTML(DESCRIPTION) , 'Analytics:' , 'Analytics' ) as ANALYTICS,

Re: Last Character for Text Between?

cbaqir — Thu, 21 Sep 2017 15:38:08 GMT

Anyone?

Re: Last Character for Text Between?

cbaqir — Thu, 21 Sep 2017 19:30:33 GMT

Maybe some sort of end function?

Re: Last Character for Text Between?

vvira1316 — Thu, 21 Sep 2017 20:34:20 GMT

Would it be possible to provide a sample HTML string (DESCRIPTION) and what all parts from that you are looking for?

Re: Last Character for Text Between?

vishsaggi — Thu, 21 Sep 2017 21:11:29 GMT

Can you share one example ID where we have data for Analytics: delimiter?

Re: Last Character for Text Between?

cbaqir — Thu, 21 Sep 2017 22:14:30 GMT

The problem is that it changes. Sometimes it is not populated with text and sometimes it's just HTML formatting.

DEFECT_ID: 6753

    Current State Summary:

    text here

    Problem Statement:

    text here

    Proposed Solution:

    text here

    Voting Statement:

   text here

    Analytics:

    <td align="left" valign="middle" width="649" height="117" style="border:

Re: Last Character for Text Between?

vishsaggi — Thu, 21 Sep 2017 22:21:31 GMT

Yes, is there any ID which has this Analytics data? I mean for other text you have some text information between right? From the ID's you have, are there any values with the text for Analytics. Just wanted to check the pattern so that we can come up with some other alternative.

Re: Last Character for Text Between?

_datadude — Thu, 21 Sep 2017 22:24:18 GMT

Hi Cassandra,

suggesting a different framework is probally not the solution you are actually looking for, but maybe this framework makes it very much easier for you?

http://html-agility-pack.net/?z=codeplex‌‌

Html Agility Pack - HTML Attributes

All the best,

Markus

Re: Last Character for Text Between?

cbaqir — Fri, 22 Sep 2017 14:31:00 GMT

I can't find one off hand.

Re: Last Character for Text Between?

cbaqir — Fri, 22 Sep 2017 14:32:23 GMT

And my issue is because sometimes there is no data, I don't know what to put here:

TextBetween( stripHTML(DESCRIPTION) , 'Analytics:' , 'Analytics' ) as ANALYTICS,

Re: Last Character for Text Between?

vishsaggi — Fri, 22 Sep 2017 14:33:30 GMT

Not sure may be put an empty string like

TextBetween( stripHTML(DESCRIPTION) , 'Analytics:' , '' ) as ANALYTICS,

Re: Last Character for Text Between?

cbaqir — Fri, 22 Sep 2017 14:44:14 GMT

Brilliant!