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

Leading Delimiter in csv flatfile

  • 1.  Leading Delimiter in csv flatfile

    Posted Tue October 17, 2006 03:43 PM

    Hi,

    I’m trying to generate a flat file using the convertToString flow. I’m trying to create a CSV file that will not contain the record identifier at the beginning of each record.

    I’ve read all the threads in regards to the recordWithNoID and the default in the FF schema. I’ve gotten to the point that I am able to generate a CSV file that does not write the record identifier at the beginning of each record, but I get a comma at the beginning instead. It is as though convertToString is not outputting the record identifier but puts a null value for the first field.

    As a result of this, when I open the file in Excel, I get a blank cell at the start of each line.

    If anyone knows how to fix this it would be very appreciated!

    regards,
    FT


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