RE: How generate a Multiformat Csv file tab delimeted

That utility is used to read/parse incoming files - not create new ones.

I've done what the OP is asking a couple of different ways.

1) Concatenate all the data fields with delimiters into one large field and then write the records.

2) Create a data structure with the delimiters included as subfields and use INZ() to set the values. I did this when it was just a quick & dirty and I didn't care about trailing spaces. You can then use RESET to "clear" the DS.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power




-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bryan Dietz
Sent: Monday, May 26, 2025 6:34 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Subject: Re: How generate a Multiformat Csv file tab delimeted

You may be able to use Scott’s utility to format the CSV file like you want.

https://www.scottklement.com/csv/


Bryan

On May 24, 2025, at 3:38 PM, gio.cot via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi All

I would need to generate a Multiformat Csv file tab delimeted (with RPG
or CLLE) ..

The CSV file have a record type (Ex. 01 Header 02 Details)

Ex.

Type record (01) customer code (0001 ) customer name (Acme Inc) invoice
number (12345) invoice date (2025/05/20)

Type record (02) Item number (AA01) item description (aaaaaaaa) item qty
(12,02)

Type record (02) Item number (BB01) item description (BBBBBBB) item qty
(33,20)



Any suggestions



Thanks in advance



Gio



--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.