Outputting to CSV File - need to eliminate the last comma

Question

I'm working on an creating a template for a software product we use. The first line of data needs to be 6 columns, the data needs to be 7 columns. When I output the finished file to CSV, the header has an extra comma and the file will not import. I'm trying to find a way where that null value in the header line will be excluded when writing to a CSV file. At the moment, I have been editing each file to remove the comma manually. There has to be an easier way.

This is what I get on output.

This is the output right before writing the .CSV file

Here are the settings for the output tool.

Any help to eliminate the very last comma in the first line would be greatly appreciated.

to8nbeyond · Answer

I'm using Thompson Reuters OneSource Income Tax. They are very specific about their import templates.

to8nbeyond · Answer

Thank you for your suggestions. Using the info for outputting to csv files with the \0 & never option, I was able to string together the required fields using an if statement within a formula tool and then output the new column. This seems to work.

Thanks for your help.

AkimasaKajitani · Answer

Hi @to8nbeyond

it needs some tricks because In this case the csv that you need is special csv file that it means not normal csv.

In this case, we needs add the delimiter and quote to the data in advance.

And we should set the output data tool below.

The most important point is "Delimiters" option. It should be set "\0" if we set the "Never" to the "Quote output Fields".

Because if we set the "Never" to the "Quote output Fields" and set space or any other character to "Delimiters", Designer shows error.

Please try it and if you have any questions, let me know.