splitting fields

venkat1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

i am having a field like

D-LB-DB-1.00-17-00k-Q5
I need sub fields like
D as sub1

LB as sub 2

DB as sub 3

1.00-17 as sub 3

00k as sub 4

Q5 as sub 5.

I used below code in my backed script
SubField(ITEM_CODE,'-',1) as substring1,
SubField(ITEM_CODE,'-',2) as substring2,
SubField(ITEM_CODE,'-',3) as substring3,
SubField(ITEM_CODE,'-',4) &'-' &SubField(ITEM_CODE,'-',5)as substring4,
SubField(ITEM_CODE,'-',5) as substring5,
SubField(ITEM_CODE,'-',7) as substring6,

But substring 4 doesnt work in my case
can anyone help me in this

Re: splitting fields

Taoufiq_Zarra — Fri, 13 Dec 2019 14:19:16 GMT

Hi,

I think that
SubField(ITEM_CODE,'-',4)&'-'&SubField(ITEM_CODE,'-',5) works well.
for the others, you made a typo, I think.

SubField(ITEM_CODE,'-',1) as substring1,
SubField(ITEM_CODE,'-',2) as substring2,
SubField(ITEM_CODE,'-',3) as substring3,
SubField(ITEM_CODE,'-',4) &'-' &SubField(ITEM_CODE,'-',5)as substring4,
SubField(ITEM_CODE,'-',6) as substring5,
SubField(ITEM_CODE,'-',7) as substring6,

Cheers,

topic splitting fields in QlikView

splitting fields

Re: splitting fields