Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • I have a text string that contains a number of custom fields , the attribute name ends with a ":" and the data ends with a ";" see example below. I want to end up with a column for each attribute in a excel spreadsheet

example of text string

Bike :SS Lightning;NDIS #:;Prefname:Jacob;GEOG CODE:46429;Referred By: Newsletter;NDIS Planner:;Continual EOI:;Customer Type:46021;Date of Birth:;RidingCommunity:Short stature;Support Co ordinator:;notification_billing:1;notification_reports:1;Allied Health Company:;Allied Health Contact:;Allied Health Position:;notification_marketing:1

 

not all features contain all of the field names. I want to end up with columns Bike, NDIS#, GEOG COde etc and the data for each attribute in a excel spreadsheet. Thanks

Idea 1: work with lists only, and use a complex AttributeCreator.

Process_Line 

Idea 2: work with lists and temporary features.

Process_Line_v2

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
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.