Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Giacinto,
try
TextBetween(Field,'<p>',</p>')
Regards,
Antonio
Don't forget the other ' :
TextBetween(Field,'<p>','</p>')
Hello Antonio,
this works perfectly fine!
Thank you.
In your command was just one single quotation mark missing:
TextBetween(Field,'<p>','</p>')