Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Add extra comma to the end of the CSV

2 Replies

0 Subscribed to this topic

13 Subscribed to this forum

Sort:

Author

Messages

Nancy

Basic Member

Posts: 13

New Poster

Engaged Reader

Avid Reader

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: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

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

New Poster

Engaged Reader

Avid Reader

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.