AnsweredAssumed Answered

Split Field value into mutliple chunks

Question asked by dinesh.mallempati104426 on Oct 10, 2018
Latest reply on Oct 11, 2018 by dinesh.mallempati104426

Hi Adam ArrowsmithJohn DiStasioSeth DudaHarikrishna Bonala

 

REQ: we were getting Filed value greater than 20 characters but in our JDE database for that field length is 20.

 

So now we need to split field value into chunks of 20 characters

 

Input:

 

<PurchaseOrder>

<F5847011>

<syedst>850</syedst>

<F5847014>

<zttxln>A USF purchase order number </zttxln>

</F5847014>

<F5847014>

<zttxln>must be supplied on the bill of lading</zttxln>

</F5847014>

<F5847014>

<zttxln>but not be limited to, sort and segregate</zttxln>

</F5847014>

 

</PurchaseOrder>

 

 

Expected OutPut each line has to be 20 characters

 

<PurchaseOrder>

<F5847011>

<syedst>850</syedst>

<F5847014>

<zttxln>A USF purchase order</zttxln>

</F5847014>

<F5847014>

<zttxln> number </zttxln>

</F5847014>

<F5847014>

<zttxln>must be supplied on </zttxln>

</F5847014>

<F5847014>

<zttxln> the bill of lading</zttxln>

</F5847014>

<F5847014>

<zttxln>but not be limited t</zttxln>

</F5847014>

<F5847014>

<zttxln>, sort and segregate</zttxln>

</F5847014>

</F5847011>

</PurchaseOrder>

 

 

Thanks,

Dinesh

Outcomes