Remove characters before and after a string.

[#1]

Is there a way to trim a string such as the one below, i cannot use trim based on len because the length varies on the values. I want everything prior to the word the removed. I cant use purge though because letters can also exists in the first portion of the string. Does anyone have ideas?

<div class="ExternalClass203E819FE1594BBC93D88712CF42A518"><p>​The data collection process for this project.

[sunny_talwar]

What are we trying to extract from the above string?

[swuehl]

I want everything prior to the word the removed.

Can you elaborate this?

Maybe you can use string functions like Textbetween():

     Textbetween(YourField, '<p>','.')

or Mid() and Index()

      Mid(YourField, Index(YourField,'<p>')+1)

[swuehl]

Or maybe have a look at

Removing HTML markup code

Re: How to remove HTML tags in Qlikview

[henrikalmen]

Do you always have <p> in the same position, and no more than one <p>-tag? If so, you could use SubField([YourString], '<p>', 2)