Space in between Header fields in output csv file.

[Former Member]

Hi All,

My scenario is Proxy to File, where the output file is csv (flat file). The problem is with the output file

where I have to populate space in between the header field in the output csv file.

for example: If the Target fields are like, SupplierNumber, CustomerAccount then the putput csv file sould be

Header fields :   Supplier Number,Csutomer Account

Can anyone quickly help on the this requirement.

Many thanks,

Rahul.

[former_member220103 · Accepted solution]

Hi Rahul,

Add a new structure in the Data type as Header.

Populate the fields with constants as "Supplier Number",

                                                       "Customer Account".

Then in Communication Channel, change the FCC parameter as

Header.fieldSeparator as ','

Header.endSeparator as 'nl'.

Then it should work.

Thanks,

Kanda

[Former Member]

Hi Rahul,

You can add header with space for your FCC in receiver file adapter. Add below two parameters in FCC, it will generate file with the headers specified.

NameA.addHeaderLine : 3

NameA.headerLine: Supplier Number,Customer Account

Regards,

Praveen

[Former Member]

Thank you Praveen I will defenitely try