+11I am using FeatureWriter to ouput a text file.
It does not put quotes around string attributes like it should.
I want
"2018-12-07 09:30:00","Canungra (Defence)",0
I get
2018-12-07 09:30:00,Canungra (Defence),0
The third column is numeric and should not have quotes
Best answer by nicholas
I solved it by switching the FeatureWriter from Format: CSV to format Test File
I used Attreibute creator to concatenate three columns into one (text_line_data) with " and , exactly where I want them.
I also used a Creator and AttributeManager to create the column names (separated by commas) as the first line
So, my solution was to avoid the csv writer and use the text file writer instead. More work, but far more control.
What I would really like is for the CSV writer to allow the quotes to be set on a column by column basis
+44Hi @nicholas
I re-criated here your case with the AttributeCreator:
After, the transformer AttributeSplitter to split in " , ". The list of attributes was created:
_list{0}
_list{1}
_list{2}
I concatenated with StringConcatenator using this configuration:
"@Value(_list{0})","@Value(_list{1})",@Value(_list{2})
Thanks,
Danilo
+11I solved it by switching the FeatureWriter from Format: CSV to format Test File
I used Attreibute creator to concatenate three columns into one (text_line_data) with " and , exactly where I want them.
I also used a Creator and AttributeManager to create the column names (separated by commas) as the first line
So, my solution was to avoid the csv writer and use the text file writer instead. More work, but far more control.
What I would really like is for the CSV writer to allow the quotes to be set on a column by column basis
If you need to always quote the 1st and the 2nd columns, you can easily do it using the StringConcatenator with the Overwrite Existing Attributes option, like this. Assuming attribute names for the 1st and the 2nd columns are "attr1" and "attr2".
+17The Parameters for the CSV writer in the FeatureWriter contain these to add quotes to the output values:
+11The Parameters for the CSV writer in the FeatureWriter contain these to add quotes to the output values:
Setting "Qualify Field Values" to Yes will force quotes on all columns, including numeric fields. I do not want quotes on numeric fields
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
