Skip to main content
Question

convert .txt to .csv


parashari
Forum|alt.badge.img+2
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 :)

 

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.

6 replies

takashi
Celebrity
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
Forum|alt.badge.img+2
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
Celebrity
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
Forum|alt.badge.img+2
Thank you so much Takashi :) Dump question it was :P

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • May 21, 2015
...lol

pratap
Contributor
Forum|alt.badge.img+12
  • Contributor
  • May 21, 2015
Text file to csv or xlsx is easy in Excel itself