Question

Extract cell rows to individual columns

W

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

2 replies

ngoorman

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.

M
Badge +2

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

28,670
Posts
109,367
Replies
36,531
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.