Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
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,