IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only
Expand all | Collapse all

I want to split my input at each 50 characters interval, by using which function how can i split .

  • 1.  I want to split my input at each 50 characters interval, by using which function how can i split .

    Posted Fri March 06, 2015 12:00 PM

    Originally posted by: hanishkola


    "販ä¿? -åº?å??å??è³?é??ï¼?ã?®ã??ã??ã?«ã?¿ã?­ã?°ï¼?1 -ï¼·ï½?ï½?ï¼?ï¼­ï½?ï½?ï½?ã?¹ã??ã?¢ã?¼ã?ºã??."

    I want the above input to split at interval of each 50 characters


    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: I want to split my input at each 50 characters interval, by using which function how can i split .

    Posted Fri March 06, 2015 01:16 PM

    Originally posted by: Tim Rabbitt


    Hello:

     

    If you want to split it on input, you can create a type tree with a structure of:

    File - defined as a group

       Inputrecord (1:s) - defined as a group

          50chars - defined as text with a min and max character setting of 50

     

    If you want to split it on output, use this as a run map, passing the entire input to this map

    I've attached the tree and map as an example

    Regards,

    Tim Rabbitt

     


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender

    Attachment(s)

    mtt
    50charinput.mtt   5 KB 1 version
    mms
    50charinput.mms   1 KB 1 version


  • 3.  Re: I want to split my input at each 50 characters interval, by using which function how can i split .

    Posted Mon March 09, 2015 06:25 AM

    Originally posted by: hanishkola


    Thanks Tim for your reply .

    I tried with your type tree and there it is repeating the first 50 characters only again and again .

     My scenario is if there are some 125 characters in input item , it should be spllt in to 50,50,25 to 3 items in out card 


    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 4.  Re: I want to split my input at each 50 characters interval, by using which function how can i split .

    Posted Mon March 09, 2015 09:11 AM

    Originally posted by: Tim Rabbitt


    Hello:

    I've revised the input tree to accept 50 bytes or less.  I used input that had one record in it that contained 50 ones, 50 twos, 50 threes and 25 fours for a total of 175 bytes.  Using the attached map, the output resulted in 4 records.  The first line was the 50 ones, the second was the 50 twos and so on.   My testing was conducted with WTX 8.4.1.2.

    Regards,

    Tim


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender

    Attachment(s)

    mtt
    50charinput.mtt   5 KB 1 version
    txt
    output.txt   183 B 1 version
    mms
    50charinput.mms   1 KB 1 version
    txt
    input.txt   175 B 1 version


  • 5.  Re: I want to split my input at each 50 characters interval, by using which function how can i split .

    Posted Mon March 09, 2015 10:20 AM

    Originally posted by: hanishkola


    Ok Tim ,

     i got it, actually before  50char Item Min sizewas also 50 , thats why i didn't got output now i changed it to 0 ,and i got now.

    Thanks Tim for your help .

     

    Thanks and Regards

    Harish 


    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 6.  Re: I want to split my input at each 50 characters interval, by using which function how can i split .

    Posted Tue March 10, 2015 04:38 AM

    Originally posted by: Laurent(Satisco)


    In 8.4.1.2, you can avoid a RUN map by using the PARSE function, which works fine for "regular" (read "non XML") data. It's not better in terms of performances, but makes less objects to manage and deploy. (We are using PARSE in my current project, so I hope we can have the support working on this XML thing and help improve it)

    In earlier versions, it's also feasible to avoid RUN by looping functional map calls, but it can sometimes be a bit clumsy.

     


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 7.  Re: I want to split my input at each 50 characters interval, by using which function how can i split .

    Posted Tue March 10, 2015 08:39 AM

    Originally posted by: Tim Rabbitt


    Hello Laurent:

    If you are interested in having WTX add functionality to the product we ask that you submit a Product Enhancement Request.  You can create, search and monitor Product Enhancement Requests at:  https://www.ibm.com/developerworks/rfe/?BRAND_ID=343

    Regards,

    Tim Rabbitt


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 8.  Re: I want to split my input at each 50 characters interval, by using which function how can i split .

    Posted Mon March 30, 2015 12:11 PM

    Originally posted by: thorstenhirsch


    Actually I'm already using PARSE on an XML Typetree imported from DTD with Xerces. So I don't think that there's a general problem with PARSE and XML. (WTX 8.4.1.2)


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 9.  Re: I want to split my input at each 50 characters interval, by using which function how can i split .

    Posted Wed March 11, 2015 04:27 AM

    Originally posted by: Laurent(Satisco)


    Hi Tim,

     

    I'm aware of the RFE process, and have already submitted some suggestions (and some were even accepted, I like this process as it makes it simpler to get in touch with the labs).

     

    In what I'm describing, there is no need for an RFE, but I had PARSE behave oddly in some cases. I'll try to build a test case and have a PMR open, to get the labs feedback on this.

     

    Best regards

    Laurent


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender