topic Re: Remove characters before and after a string. in QlikView

Remove characters before and after a string.

Thu, 12 May 2016 13:40:51 GMT

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">The data collection process for this project.

Re: Remove characters before and after a string.

sunny_talwar — Thu, 12 May 2016 16:58:31 GMT

What are we trying to extract from the above string?

Re: Remove characters before and after a string.

swuehl — Thu, 12 May 2016 16:59:21 GMT

I want everything prior to the word the removed.

Can you elaborate this?

Maybe you can use string functions like Textbetween():

Textbetween(YourField, '','.')

or Mid() and Index()

Mid(YourField, Index(YourField,'')+1)

Re: Remove characters before and after a string.

swuehl — Thu, 12 May 2016 17:02:00 GMT

Or maybe have a look at

Removing HTML markup code

Re: How to remove HTML tags in Qlikview

Re: Remove characters before and after a string.

henrikalmen — Fri, 13 May 2016 08:34:30 GMT

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