topic Re: starts with function in a textbetween function in QlikView

starts with function in a textbetween function

diwaskarki — Thu, 30 Aug 2018 04:25:23 GMT

Hello guys,

I am using a textbetween function to extract some string from an xml that is stored in a one of the columns in my db2 table. This is what the data looks like.

I am extracting the strings thats stored inside the list with this function:

TextBetween(Replace(Replace(Replace(Replace(ATTRIBUTES,chr(10),' '),' ', ''), '<String>', ''), '</String>', chr(10)), '<entrykey=" Starts with function?"><value><List>', '</List>') As [Removed Role Entitlements1],

I need a starts with function to use here.

I have used this function , where I could just hard code the entry key but the value here is dynamic except it always starts with _

I would really appreciate the help. rwunderlich‌susovan.g‌marksmunich‌ stalwar1‌

Re: starts with function in a textbetween function

marcus_sommer — Thu, 30 Aug 2018 05:37:40 GMT

Take a look on this approach: Re: XML within a column - need to parse.

- Marcus

Re: starts with function in a textbetween function

diwaskarki — Thu, 30 Aug 2018 14:02:01 GMT

Hi Marcus,

I dont think this would apply to my data, since I dont have a separate node for the data I want to extract. Its in a list.

Re: starts with function in a textbetween function

marcus_sommer — Fri, 31 Aug 2018 05:11:54 GMT

I think you should try to load the data as xml (just store one or two fieldvalues from the xml within a textfile and then loading from there with xml as fileformat per file-wizard and playing with it) . Even if you don't get your wished results directly it should be easier to extract it from this output.

- Marcus

Re: starts with function in a textbetween function

diwaskarki — Wed, 05 Sep 2018 18:44:25 GMT

I will definitely try it.