Skip to main content
Solved

convert .txt (tab space) to attribute

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.

View original
1 Attachments
Did this help you find an answer to your question?

3 replies

ebygomm
Influencer
Forum|alt.badge.img+32
  • ebygommInfluencer
  • Influencer
  • August 6, 2019

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

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

It doesn’t work on my FME 2016.

takashi
Influencer
  • takashiInfluencer
  • 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.

Reply


Helpful Members This Week

Community Stats

31,142
Posts
118,070
Replies
38,761
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.