Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • I have a pling delimited text file with the attribute names in the first row. How do I split the data AND put each attribute in a field whose name corresponds to the attribute name in the first row? A sample of the first five rows in below.

refid|type|latitude|longitude|source|add_dt|pressure_sys|situs_addr|situs_frac|situs_pre|situs_stree|situs_suff|situs_post|situs_suit|situs_buil|situs_juri|situs_zip|chg_dt

 

344122-1|SVCPT|32.7655812974478|-117.032253396029|GIS|1/25/2017|LM, LG, SV Gravity - 656|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset

 

302698-1|SVCPT|32.7659789784174|-117.023796522145|GIS|1/25/2017|LM, LG, SV Gravity - 656|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset

 

355862-1|SVCPT|32.7566364143178|-117.014639927890|GIS|1/25/2017|LM, LG, SV Gravity - 656|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset

 

302723-1|SVCPT|32.7641617522751|-117.023556288137|GIS|1/25/2017|LM, LG, SV Gravity - 656|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset

A CSV reader with | delimiting character will do it.

A CSV reader with | delimiting character will do it.

I can't do that because some of the fields have attributes with commas.

 

 

Oops maybe I can @bruceharold. I think I tried that already but will try again.

Thanks @bruceharold! Making the change in the Field Separation Parameter while adding the reader worked - versus what I'd tried earlier which was after the fact, using an attribute splitter with pling as the delimiter.

Thanks @bruceharold! Making the change in the Field Separation Parameter while adding the reader worked - versus what I'd tried earlier which was after the fact, using an attribute splitter with pling as the delimiter.

I learned something too - I never heard a '|' being called a 'pling' before! :-)

 

 

Reply


Community Stats

30,099
Posts
114,259
Replies
37,729
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.