Header Line in content conversion of file receiver communication channel

[former_member615274]

Hello,

I would add header line in csv file, with free columns text, using NameA.addHeaderLine = 3, but when I insert in NameA.HeaderLine, my free texts separated by comma, appear all in the first column of the first row of csv, as described below.

A,B,C,D,E,F,G,H,I,L
I	4012003	30092017	E/0412	1679	Duplication of key
I	4012003	30092017	E/0412-0	26001	Duplication of key
I	4012003	30092017	E/0412-0	26001	Duplication of key
I	4012003	30092017	E/0412-0	26001	Duplication of key

My content conversion is

ZTASRecord.addHeaderLine	3
ZTASRecord.HeaderLine	A,B,C,D,E,F,G,H,I,L
ZTASRecord.fieldSeparator	;
ZTASRecord.fieldNames	ACTION,START_PERIOD,END_PERIOD,WBS_ELEMENT,ASSINED_OU,ASSIGNED_PERSONNEL_NUMBER,WP_ID,WORKPKG_TITLE,RecResult,FileResult
ZTASRecord.endSeparator	'nl'
ignoreRecordsetName	true

How can I split the HeaderLine texts in columns?

Regards

Maria

[Former Member]

Hi Maria

There is a minor probelm with your paramter name. The correct paramter name is

Record.headerLine

But you have used as Record.HeaderLine. Change that name. Also once the csv file generated download it and open it with excel, you will see desired output.

Please find below my test

data type:

FCC:

Output:

[anandvithal]

Hi Maria,

Not sure if we can have two different field separators in header and data records.

So use comma in the field separator.

ZTASRecord.fieldSeparator    ,

Thanks,

Anand

[vedrankubelka]

You can try with

ZTASRecord.HeaderLine

A;B;C;D;E;F;G;H;I;L

[former_member615274]

it does not work

[gagandeep_batra]

Hi Maria,

I think your field separator also not working ";"

right?

Regards

Gagan

[former_member615274]

Hi,

the field separator works for other table fields from second row, in fact in the example above the data are splitted in column, only header is not splitted.

reards

Maria

[gagandeep_batra]

What is your field seprator ";" or tab beacause i m not able to see ; in your 2nd record;

& try without "ZTASRecord.fieldNames"

Regards

gAgan