IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

How to split a field into 2

  • 1.  How to split a field into 2

    Posted Tue February 02, 2010 03:18 PM

    Hi all,

    i have a requirement where I have to split a field into 2 and map it to two different fields.

    For example, They are sending a field…which has David, Richard value.

    They are sending (,) in the field…and I need to send David to one field and Richard to another field.

    So, I have to map value before (,) to one field and value after(,) to another field.

    Can you guys please help me to write the logic to split.

    Regards,
    David.


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 2.  RE: How to split a field into 2

    Posted Tue February 02, 2010 03:41 PM

    Use either pub.string:indexOf and pub.string:substring or
    pub.string:tokenize (check if the delimiter can be there multiple times and if this is expected behaviour first)

    usually I prfer using those as transformers in a map step, not via invoke.

    details to be found in Integration_Server_Built-In_Services_Reference


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


Related Content