topic String Manipulation in QlikView

String Manipulation

Wed, 03 Aug 2011 02:30:41 GMT

I was hoping someone could please steer me in the right direction. I have tried nested do while loops with no avail. I have a source document that reads for example a record with 2 fields
field1, This; is; a; sample
that I would like to convert to (in this case) 4 records delimter being the semi colon (;)

i.e:

field1, This
field1, is
field1, a
field1, sample

in a load statement

Re: String Manipulation

lironbaram — Wed, 03 Aug 2011 05:09:02 GMT

hei

attach is an example of what you asked for

using Subfield

the script of the file is writen like this:

datatemp:

load subfield(Field1,';') as Field1;
LOAD * INLINE [
Field1
This;Is;a;Sample
];

Re: String Manipulation

Wed, 03 Aug 2011 22:32:33 GMT

Thanks Liron, that does exactly what I wanted.