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
Expand all | Collapse all

Difference between the quoted release character and release character ?

  • 1.  Difference between the quoted release character and release character ?

    Posted Thu January 04, 2018 11:08 AM

    Hello Experts,

    Can anyone please clarify what is the difference between Quoted release character and release character.

    thanks in advance.

    Thanks,
    Ram.


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


  • 2.  RE: Difference between the quoted release character and release character ?

    Posted Thu January 04, 2018 01:49 PM

    Hi Ramanjaneyulu,

    can you specify, where you have met this setting?

    FlatFile Handling?

    Regards,
    Holger


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


  • 3.  RE: Difference between the quoted release character and release character ?

    Posted Fri January 05, 2018 07:10 AM

    @Thomsen

    Yeah, It is in flat file processing.

    Thanks,
    Ram.


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


  • 4.  RE: Difference between the quoted release character and release character ?

    Posted Fri January 05, 2018 07:50 AM

    Hi,

    in this case there should be a note in the FlatFile Users Guide which explains the difference.

    Regards,
    Holger


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


  • 5.  RE: Difference between the quoted release character and release character ?

    Posted Fri January 05, 2018 09:29 AM

    @Thomsen

    Thanks for your quick reply…
    I have gone through that previously, need more clarity on this with an example.

    Thanks,
    Ram.


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


  • 6.  RE: Difference between the quoted release character and release character ?

    Posted Mon January 08, 2018 02:10 PM

    They are just two different ways to enable you to include the delimiter in the data.

    For example, let’s say you have a CSV file where your delimiter is a comma (,). How can you then include a comma in the data?

    You can do it in one of two ways:

    (a) You can use the quoted release character to wrap that entire field, e.g. if my quoted release character is ", my field may appear in the file as:

    …,“example of a comma (,) in the data”,…

    (b) You can just use the release character, e.g. if my release character is , my field may appear in the file as:

    …,example of a comma (,) in the data,…

    Percio


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