Question

convert .txt to .csv

parashari
Badge +1
Hi. Working on FME2015 32-bit. I have a text file (.text) which contains schema in its first row. I want it to convert to csv file. Each entity is enlosed in inverted commas and all the attributes are seperated by a comma. Is there any possible way to convert a text file to a csv file? PFA- image (txt2csv.jpeg)

 

I have tried using AttributeSplitter using expose elements but it it showed only one attribute at at time. Thanks :)

 

6 replies

takashi
Rank
Userlevel 2
Badge +17
Looks like the text is written in the CSV format already.

 

I don't think any conversion is necessary...

 

 

What kind of transforming do you need?
parashari
Badge +1
I just wanted to know how can we convert a text file to a csv file (if we can) when the values are seperated by a comma,. Since I come across many issues like the conversion of text file to csv, xlsx, shp etc, so I just wanted to know about it. Consider the image as an example.
takashi
Rank
Userlevel 2
Badge +17
CSV is "Comma Separated Values".

 

If the values in the text have been seperated by commas, that is the CSV.

 

Am I missing something?
parashari
Badge +1
Thank you so much Takashi :) Dump question it was :P
G
Badge +3
...lol
pratap
Rank
Badge +2
Text file to csv or xlsx is easy in Excel itself

Reply


Community Stats

28,709
Posts
109,481
Replies
36,554
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.