Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gino2780
Contributor

edit string value with subfield

Hello dear community,

i'd like to cut the middle part of values from a string that comes from a sharepoint-site.

This is how a sample row looks like in SharePoint:

and this is the exact same sample row in qlik after connecting all the list data via REST-Connector:

I want to extract only the part of the string, that is in the red rectangle.

So far i've tried to work with the subfield command, e.g.:

subfield([ows_K_x00fc_ndigungsgrund], '>', 3) as Kündigungsgrund

This results in:

I have trouble to cut also the part of the string: </p

Any suggestions on how i can get rid of the parts of the string before and after the real value, so that only the value is left over?

Tags (2)
1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: edit string value with subfield

Hi Giacinto,

try

TextBetween(Field,'<p>',</p>')

Regards,

Antonio

3 Replies
antoniotiman
Honored Contributor III

Re: edit string value with subfield

Hi Giacinto,

try

TextBetween(Field,'<p>',</p>')

Regards,

Antonio

omarbensalem
Esteemed Contributor

Re: edit string value with subfield

Don't forget the other ' :

TextBetween(Field,'<p>','</p>')

gino2780
Contributor

Re: edit string value with subfield

Hello Antonio,

this works perfectly fine!

Thank you.

In your command was just one single quotation mark missing:

TextBetween(Field,'<p>','</p>')