Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gino2780
Creator
Creator

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?

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Giacinto,

try

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

Regards,

Antonio

View solution in original post

3 Replies
antoniotiman
Master III
Master III

Hi Giacinto,

try

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

Regards,

Antonio

OmarBenSalem

Don't forget the other ' :

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

gino2780
Creator
Creator
Author

Hello Antonio,

this works perfectly fine!

Thank you.

In your command was just one single quotation mark missing:

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