Prev
Next
Forums Integration / Customization S3 Interfaces/Conversion

Add extra comma to the end of the CSV

 2 Replies
 0 Subscribed to this topic
 11 Subscribed to this forum
Sort:
Author
Messages
Nancy
Basic Member
Posts: 13
Basic Member
3/28/2012 6:30 PM
    We have a 4GL program that we have written to output a CSV file for one of our vendors.
    The vendor has stated that they need a ',' at the end of each CSV record after the last field in that record.

    Does anyone know how to get the extra comma at the end of the last field?  We thought about adding another field to the record and just moving a comma into the field but because the file has each field enclosed in double quotes  the comma ends up being in double quotes also.
     
    Any help would be appreciated.
    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
    3/28/2012 6:49 PM
      After adding the extra field, what if you do not populate the field ? I would think the additional null field would show up as an extra comma ?
      Nancy
      Basic Member
      Posts: 13
      Basic Member
      3/28/2012 7:18 PM
        Thanks Ragu - That did what I wanted.  I was trying to use this "INFO-LINE-TERM (Lawson 4GL)" which I found in the "Doc for Developers: Lawson 4GL Application Program Interfaces" manual but could not get it to work.