splitting fields

[venkat1]

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

[Taoufiq_Zarra · Accepted solution]

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,