I have csv data in a single attribute like this (field names are first line).
Grower,Date,SampleNum,P,K,C
1000,05/01/2018,350,275,1500
how can I parse this into feature(s) with the correct collums using fme?
Solved
Any ideas how to parse csv data in single attribute?
+7- Contributor
Best answer by david_r
I believe this answer should cover your case:
https://knowledge.safe.com/questions/78520/parse-csv-data-stored-in-database-table.html
The first feature will contain the attribute names, the following features will contain the values. If necessary you can use the Sampler to get rid of the first feature.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+26- Contributor
In the CSV reader you can:
- Check the box to have field names in the first row
- Determine the , to be the separator
FME will then read all rows and use the first row for attribute naming.
+7- Contributor
In the CSV reader you can:
- Check the box to have field names in the first row
- Determine the , to be the separator
FME will then read all rows and use the first row for attribute naming.
+26- Contributor
Sorry, I wasn't very clear, my data originates in an attribute downloaded from a webservice, not an actual csv file.
But use the AttributeFileWriter to write to a CSV file, followed by a FeatureReader to read as CSV.
Sorry, I wasn't very clear, my data originates in an attribute downloaded from a webservice, not an actual csv file.
+7- Contributor
In the CSV reader you can:
- Check the box to have field names in the first row
- Determine the , to be the separator
FME will then read all rows and use the first row for attribute naming.
- Best Answer
I believe this answer should cover your case:
https://knowledge.safe.com/questions/78520/parse-csv-data-stored-in-database-table.html
The first feature will contain the attribute names, the following features will contain the values. If necessary you can use the Sampler to get rid of the first feature.