Skip to Content
0
Former Member
May 17, 2010 at 08:47 AM

mapping help Spliting string

42 Views

Hello Experts,

My requirement is,

Source:

MT_Elemica_Orders_Out
       Orders_Create
                 OrderString     length 140

Target:

MT_B2B_DB
    Orders_Update  1to Unbounded
           TEXTLine       length 70
           TextFormat

If the length of the source fields is more then 70 characters then I want below output in target structure

Expected:Traget:

MT_B2B_DB
    Orders_Update
        TEXTLine (first 70 charcters)
        TextFormat(* (Constant))
        TEXTLine(Remaing characters after 70)
        TextFormat(= (constan)).

How can I achieve this????

many thanks,

Jam