SubField Function in qlikview

[#1]

Hi all,

From the following, I jus want LA_GRMTH as the output.

Is this possible using SubField function?

"RPRPLA_GRMTH_CD","relatedparty":"'

Thanks all for you help.

Vidhya

[swuehl]

Can you create a small INLINE script with the current code you are using (e.g. from Max Dreamer) and some sample records? So that we can see where it has not delivered the expected results?

[swuehl · Accepted solution]

You can maybe use the occurence index in Textbetween() function:

TextBetween(FORM_DATA,'"relationshipinfo":[{"relationship":"R','_CD',1)as Primary_Relation,

TextBetween(FORM_DATA,'"relationshipinfo":[{"relationship":"R','_CD',2)as Secondary_Relation,

Secondary_Relation should be NULL in most records. You can decide what you want to do with these fields, e.g. concatenate into one or create a Hierarchy out of that.

[#4]

Thanks Swuehl.

Your suggestion worked.

[#5]

Thanks all for your effort