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

Handling CSV containing 'Comma' & &

  • 1.  Handling CSV containing 'Comma' & &

    Posted Thu October 10, 2002 03:52 AM

    Hi,

    I have CSV data which is created from EXCEL, in which few field have COMMA and double quotes.
    for example:

    umashanker,"Address here,test "“data”, 273-0006

    I have create a custom CSV template, but when i read the data by using the template my pipeline is:

    Name=umashanker
    Address="Address here
    PostalCode=test "“data”

    How can i handle this kind of data by using WmEDI package templates and service?

    Any advice welcome.

    Thanks in advance


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB