webMethods

webMethods

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
  • 1.  remove whitespaces from document fields

    Posted Thu September 13, 2018 08:51 AM

    Hi,
    I am converting a fixed length flat file to doc. Due to this many fields have white spaces. Is there any java service to remove these white spaces or should I use trim for all the fields?


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


  • 2.  RE: remove whitespaces from document fields

    Posted Thu September 13, 2018 11:07 AM

    If you are using pub.flatFile:convertToValues service then use the flag trimwhitespace in the input.


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


  • 3.  RE: remove whitespaces from document fields

    Posted Fri September 14, 2018 07:20 AM

    Thank you, but I am working on SAG 9.9 designer and there is a skipWhiteSpace option, but this not doing the desired job, as now my flat file is failing against schema validation.
    Since this is a fixed length flat file, fields which do not have any values, have spaces instead.
    For eg. : Even the field of length 25, and has only 2 char input will have value as
    string1="25 "


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


  • 4.  RE: remove whitespaces from document fields

    Posted Tue October 02, 2018 03:48 PM

    flags/trimWhitespace is the input you want to set, not skipWhiteSpace.


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


  • 5.  RE: remove whitespaces from document fields

    Posted Fri October 05, 2018 06:59 AM

    A big Thank You to both of you for the help.


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