Add extra comma to the end of the CSV

Prev Go to previous topic

Go to next topic

Last Post 3/28/2012 7:18 PM by Nancy

2 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

Nancy
Senior Systems Analyst
Heartland Regional Medical Center

(27 points)
Basic Member
Posts:13

Send Message:

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
Private
Private

(1300 points)
Veteran Member
Posts:452

Send Message:

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
Senior Systems Analyst
Heartland Regional Medical Center

(27 points)
Basic Member
Posts:13

Send Message:

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.

You are not authorized to post a reply.