topic Re: How to use subfield function for different separators in QlikView

How to use subfield function for different separators

Anonymous — Tue, 07 Nov 2017 13:25:26 GMT

Hi All,

How to use subfield function for different separators ?

Raw data:

Apple : Banana

Orange : Banana

Apple - Banana -Milk

Apple - Banana -Milk - Coffee

Orange : Banana - Tea

Output:

Thanks,

Krishna.

swuehl — Tue, 07 Nov 2017 13:29:31 GMT

You can first REPLACE() all different separators to a common one, then use SUBFIELD().

sunny_talwar — Tue, 07 Nov 2017 13:30:06 GMT

Try this

Table:

LOAD A,

SubField(A, ' ', 1) as B,

Mid(A, Len(SubField(A, ' ', 1))+4) as C;

LOAD * INLINE [

Apple : Banana

Orange : Banana

Apple - Banana -Milk

Apple - Banana -Milk - Coffee

Orange : Banana - Tea

];

Anonymous — Tue, 07 Nov 2017 14:01:33 GMT

Thanks sunny