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

Convert a space seperated stringList to Tab delimited

  • 1.  Convert a space seperated stringList to Tab delimited

    Posted Tue April 27, 2010 03:15 PM

    Doing a get from a database and the results are returned in a stringList with a single space as the seperator. Would like to replace the single space with a tab delimitor.

    Problem I am having is working out the correct regular expression to use in the pub.string:replace

    searchString = \s - this seems to be fine
    replaceString = \t - not so fine and the single space is replaced with a t
    useRegex = true

    Any help would be greatly appreciated.

    Bryan

    Running Developer 6.5


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


  • 2.  RE: Convert a space seperated stringList to Tab delimited

    Posted Tue April 27, 2010 04:18 PM

    When setting the replaceString field, right-click and select “Use larger editor”. In the editor, type the tab (not \t).


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


  • 3.  RE: Convert a space seperated stringList to Tab delimited

    Posted Fri April 30, 2010 10:28 AM

    Thanks Rob. Twas as simple as that.


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


Related Content