load from internet

[francisvandergr]

I wanna load data from internet. the problem is i get one line which i wanna split at every } . How can i do this. I have an attachment.

So every new id must be a new record in qlikview. How can i do this

[MayilVahanan]

HI

PFA

Are you expecting like this..

i can't reload the data. so i test in textbox object. use subfield() for split, if you want to remove []{} braces, use purgechar() .

Want to replace unwanted character, use replace() function

Hope it helps

[francisvandergr]

Sorry this is not what i mean. I have in your way the end of the record. But at that point a new record has to start. So i wanna have 5 records for all 5 id's

First record start with ID 7383

Second record start with 8242

third 7907 etc.

[MayilVahanan · Accepted solution]

HI

PFA

[francisvandergr]

thnx