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() )
Here's a way. similar to @CoG
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
@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.
You could also just brute force it. Not quite as elegant, but it is effective!
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.
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 @CoG 's approach
