Skip to main content
Best Answer

Splitting data from excel cells

  • March 27, 2017
  • 3 replies
  • 94 views
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
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 replies

takashi
Celebrity
  • takashiCelebrity
  • 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
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
S

Thanks @takashi, that worked like a charm.

gisuser
Participant
Forum|alt.badge.img+4
  • gisuserParticipant
  • Participant
  • October 24, 2019

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?

Community Stats

32,184
Posts
122,181
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.