Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove characters before and after a string.

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.

4 Replies
sunny_talwar

What are we trying to extract from the above string?

swuehl
MVP
MVP

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
MVP
MVP

henrikalmen
Creator
Creator

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)