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.  Parsing CSV Flatfile with comma in the fields

    Posted Thu October 15, 2015 02:57 PM

    Hi All,
    I am learning how to parse a flatfile in webMethods. While working with CSV flatfile, I do not understand how to parse a flatfile with comma in the fields. I have parsed a flatfile without comma in the fields and is working. Kindly help me where to make the necessary configurations.

    Regards
    Veena


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


  • 2.  RE: Parsing CSV Flatfile with comma in the fields

    Posted Thu October 15, 2015 05:45 PM

    Did you review the 9-8_Flat_File_Schema_Developers_Guide.pdf

    There are many topics and tutorials available on tech community. You can refer them.

    If you still have issues share your CSV file and I will post the code sample at my convenient time.


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


  • 3.  RE: Parsing CSV Flatfile with comma in the fields

    Posted Thu October 15, 2015 05:59 PM

    Thank you for the response. So there is no direct way of handling this issue? Do I have to handle this through code?


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


  • 4.  RE: Parsing CSV Flatfile with comma in the fields

    Posted Fri October 16, 2015 05:57 AM

    Attach your CSV lets see what can be done.


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


  • 5.  RE: Parsing CSV Flatfile with comma in the fields

    Posted Fri October 16, 2015 12:19 PM

    Thank you Mahesh. It worked for me . I used release character.


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


  • 6.  RE: Parsing CSV Flatfile with comma in the fields

    Posted Fri October 16, 2015 12:22 PM

    NP :slight_smile:


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


  • 7.  RE: Parsing CSV Flatfile with comma in the fields

    Posted Fri October 16, 2015 05:48 PM

    I have a new question here. I am working on variable length flat file. I am getting

    “Variable Length file format invalid, file ended before record filled” exception.

    My file looks like this :
    NULL 12345,Rakesh,12-08-2013,BLR,GCS
    NULL%1235,Raghavendra,12-08-2013,BLR,GCS
    is there anything wrong is this?


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


Related Content