Skip to main content
Solved

Splitting data from excel cells

S

Hi All,

I could use some assistance on the problem I am facing.

The data I have looks something like this.

R-AMT517 C-ACB941, C-ACB942, C-ACB943

I want it to look like this.

R-AMT517 C-ACB941 R-AMT517 C-ACB942 R-AMT517 C-ACB943

How would I go about doing that?

 

Regards,

 

Sahil

Best answer by takashi

Hi @sahilbhouraskar, a well known method is:

  1. AttributeSplitter: Split the comma separated values at comma into individual parts and save them in a list attribute.
  2. ListExploder: Explode the feature on the list
View original
Did this help you find an answer to your question?

3 replies

takashi
Influencer
  • takashiInfluencer
  • Best Answer
  • March 27, 2017

Hi @sahilbhouraskar, a well known method is:

  1. AttributeSplitter: Split the comma separated values at comma into individual parts and save them in a list attribute.
  2. ListExploder: Explode the feature on the list
S

Thanks @takashi, that worked like a charm.

G
  • gisuser
  • October 24, 2019
takashi wrote:

Hi @sahilbhouraskar, a well known method is:

  1. AttributeSplitter: Split the comma separated values at comma into individual parts and save them in a list attribute.
  2. ListExploder: Explode the feature on the list

Hi @takashi how we can do that if the case like below?

The data I have looks something like this.

R

A, B, C

?, ?, ?

I want it to look like this.

R

A

?

R

B

?

R

C

?

How would I go about doing that?

Reply


Helpful Members This Week

Community Stats

31,195
Posts
118,249
Replies
38,801
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.