Question

Extract cell rows to individual columns

Forum|Forum|8 years ago
June 5, 2017
2 replies
143 views

winnie

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

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.

+3

ngoorman
Contributor
Forum|Forum|8 years ago
June 5, 2017

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.