PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/28/2012 3:18 PM by  Nancy
Add extra comma to the end of the CSV
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Nancy
Senior Systems Analyst
Heartland Regional Medical Center
Basic Member
(27 points)
Basic Member
Posts:13


Send Message:

--
03/28/2012 2: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
    Private
    Private
    Veteran Member
    (823 points)
    Veteran Member
    Posts:287


    Send Message:

    --
    03/28/2012 2: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
    Senior Systems Analyst
    Heartland Regional Medical Center
    Basic Member
    (27 points)
    Basic Member
    Posts:13


    Send Message:

    --
    03/28/2012 3: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.
    You are not authorized to post a reply.