CSV output - add a delimiter at the end of a row

[IMSL]

Hi all,

I am using an output tool to create a CSV file. I need to add a ; to the end of each row. Does anyone know how to add it?

(the value for "Valuation Code" field is Null() )

[caltang]

Before your output tool, just add a formula tool and call it " ", and the data type set to v_wstring at 255 length - the content, just put " " - it'll push the ; for the end.

The delimiter must have a field thereafter, otherwise ; cannot be forced via Output tool

[IMSL]

@caltang Thanks for your reply, but your solution did not give me what I wanted:

I also tried this, and did not work:

Also tried to change the name of new column from " " to Space by using a select tool. But that one also did not help.

[AndrewDMerrill]

You could also just brute force it. Not quite as elegant, but it is effective!

[AndrewDMerrill]

If you need it to be more dynamic, that can be done, but the workflow will be a lot more complicated, involving the Transpose Tool.

[caltang]

Another way is to concat all fields after transpose with a summarise tool as one field, then drop all other fields. 

When outputting, drop the option to include field names, then your data should have all the “;”s mashed together. 

EDIT: I've tried it myself and it didn't work - theory can only take me so far... The semicolon is forced out once the setting is disabled, my bad. @IMSL you can try @AndrewDMerrill 's approach

[TimN · Accepted solution]

Here's a way.  similar to @AndrewDMerrill