final delimiter for header record.

[ds_user78]

Hi, I have a requirement to generate a | delimited file. The final delimter of the record also should be |. I specified the First line is column header to true. I set the record level final delimiter to |. I set the Field level delimiter to |. I am getting everything properly except the final delimiter of the header record. The header record does not have the final delimiter. Is there a way to get the final delimiter on the header record?
Thanks

[sri1dhar]

Hi, I have a requirement to generate a | delimited file. The final delimter of the record also should be |. I specified the First line is column header to true. I set the record level final delimiter to |. I set the Field level delimiter to |. I am getting everything properly except the final delimiter of the header record. The header record does not have the final delimiter. Is there a way to get the final delimiter on the header record?
Thanks

I think you should also be setting Record delimiter property.

[ray.wurlod]

Not easily. You could echo the header to the file in a before-job subroutine and then set "header row" to False in the stage, which would then need to Append to the file.

[ds_user78]

Thanks every one for the replies.

Just wanted to post the solution so that it could be useful to some one. I used record delimiter string='|\n' and it worked for both the header record and the data records.