Skip to main content
Solved

Data with UTF-16Le encoding.

  • August 15, 2019
  • 2 replies
  • 93 views
bhanu_v
Forum|alt.badge.img

I am looking at valve turning data from a hand held device which is stored in an access database.

The database has torque charts stored as an attribute in one of the tables ,It is an encoded (UTF-16LE)

My intention is to split this into separate columns and make an histogram chart from it.

Any direction on how to get at it will be very much appreciated.

Best answer by debbiatsafe

Hi @adi

Based on the structure of your data, I would suggest using a combination of AttributeSplitter (split on new line character), ListExploder to create features for each line in the torque chart, and then another AttributeSplitter (split on the delimiter character for each attribute). You should then be able to create attributes using an AttributeManager or AttributeCreator. You may also want to use a Tester to only get lines that are not header lines (ie. data only) after the second AttributeSplitter.

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.

2 replies

debbiatsafe
Safer
Forum|alt.badge.img+21
  • debbiatsafeSafer
  • Safer
  • 648 replies
  • Best Answer
  • August 16, 2019

Hi @adi

Based on the structure of your data, I would suggest using a combination of AttributeSplitter (split on new line character), ListExploder to create features for each line in the torque chart, and then another AttributeSplitter (split on the delimiter character for each attribute). You should then be able to create attributes using an AttributeManager or AttributeCreator. You may also want to use a Tester to only get lines that are not header lines (ie. data only) after the second AttributeSplitter.

bhanu_v
Forum|alt.badge.img
  • bhanu_v
  • Author
  • 30 replies
  • August 23, 2019

Hi @adi

Based on the structure of your data, I would suggest using a combination of AttributeSplitter (split on new line character), ListExploder to create features for each line in the torque chart, and then another AttributeSplitter (split on the delimiter character for each attribute). You should then be able to create attributes using an AttributeManager or AttributeCreator. You may also want to use a Tester to only get lines that are not header lines (ie. data only) after the second AttributeSplitter.

This is exactly what I was looking for , Richard Mosley from FME support has also suggested the same and I was able to accomplish what I was after.

Thanks

Community Stats

32,079
Posts
121,818
Replies
39,714
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.