Skip to main content
Solved

convert .txt (tab space) to attribute

  • August 6, 2019
  • 3 replies
  • 97 views

tannyngtf
Forum|alt.badge.img

Hi Everyone

I have .txt as attached, the first line is the schema and separated with "tab" space. I can open this is in excel like .csv however I want to read this in FME and create attribute for each schema at first row. I tried attributesplitter with "tab" as delimiter but it seem not as what I want. Can anyone show me how to do it?

the input file

 

Expected attribute to be in FME to process

Thanks.

Best answer by takashi

It should work in FME 2016 too, if you set "tab" to the Separator Character parameter explicitly when adding the CSV reader to the workspace.

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.

3 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • August 6, 2019

You can use a csv reader to read in the text file


tannyngtf
Forum|alt.badge.img
  • Author
  • 4 replies
  • August 6, 2019

It doesn’t work on my FME 2016.


takashi
Celebrity
  • 7843 replies
  • Best Answer
  • August 6, 2019

It should work in FME 2016 too, if you set "tab" to the Separator Character parameter explicitly when adding the CSV reader to the workspace.