Clean up csv data

Question

I have a csv separated by semicolon. Some lines have too many semicolons (bad data). To clean up the data I have read the csv with a Text File Reader to read line-by-line and used an AttributeCreator to create an attribute for the number of semicolons in each line. Then I followed that up with a Tester to retrieve the lines with the correct number of semicolons (clean data). Now I have this text line data and need to write back to a csv. I cannot figure out how to write to a csv from the text line data.

Page 1 / 1

You can use the Text writer and append to the existing CSV file or write to a new file (using the filename <my_filename>.csv).

thanks, I eventually came to the same conclusion and it works.

Reply

erik_jan · Accepted Answer

You can use the Text writer and append to the existing CSV file or write to a new file (using the filename <my_filename>.csv).

brian_c · Answer

thanks, I eventually came to the same conclusion and it works.

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded