Skip to main content
  • EN

Hi, this is probably a very simple question but the brains not working this morning. I can do this in excel but want to know how to do this in FME.I have a cell with an address split by new rows (Char(10) and I want to split this cell and put the outputs into new, individual columns

example

DetailsNameOfficeRoadTownCountyPostcode

John Smith

 

Corporation Building

 

Common Road

 

London

 

City of London

 

W1 2DE

DetailsNameOfficeRoadTownCountyPostcode

John Smith

Corporation Building

 


Common Road

 


London

 


City of London

 


W1 2DE

and I want this


DetailsNameOfficeRoadTownCountyPostcode

John Smith
Corporation Building

 


Common Road

 


London

 


City of London

 


W1 2DEJohn SmithCorporation BuildingCommon RoadLondonCity of LondonW1 2DE

Hi winnie,

The simplest way to do this is to use the AttributeSplitter, and using the carriage return (/r) as the delimiter. That will generate a list, after which you can use an AttributeCreator to define Name as list{0}, Office as list{1}, etc.

Hi @winnie

 

Here is a nice article on how to transpose data using FME:

https://knowledge.safe.com/articles/31701/transpose-a-table-using-fme.html

I hope this helps.

Cheers.

Lyes

Reply


Community Stats

30,141
Posts
114,392
Replies
37,775
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.