topic Looping Strings in Load Script in QlikView

Looping Strings in Load Script

Tue, 17 Jan 2012 22:43:51 GMT

Hi There,

Are there any examples of functions that can be used in the load script that loop over a string?

Even split the string into an array and loop the array?

I'm trying to do this...

http://community.qlik.com/thread/41760

Looping Strings in Load Script

Wed, 18 Jan 2012 08:01:15 GMT

Hi,

in the following example string from values variable is split into tokens with ',' delimiter. In for loop each token (value variable) can be processed separately. Maybe you can modify it to your needs.

set values='a,b,c';

let commaCount=SubStringCount(values,',');

for i=1 to commaCount + 1

let value=subfield(values,',', i);

next

regards

Looping Strings in Load Script

nstefaniuk — Wed, 18 Jan 2012 08:08:47 GMT

I have replied in the previous thread