span8
span4
span8
span4
I 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
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
The Parameters for the CSV writer in the FeatureWriter contain these to add quotes to the output values:
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".
I re-criated here your case with theAttributeCreator:
After,the transformerAttributeSplitterto split in ",".The list of attributes was created:
_list{0}
_list{1}
_list{2}
I concatenated withStringConcatenatorusing this configuration:
"@Value(_list{0})","@Value(_list{1})",@Value(_list{2})
Thanks,
Danilo
KML to CSV0 Answers
writing csv-file,unwanted type conversion2 Answers
How to expose file name as fme_feature_type attribute value4 Answers
Write "" in a csv1 Answer
© 2019 亚搏在线Safe Software Inc |Legal