Skip to main content
Solved

Duplicate lines who contains a specific character

geo-x
Contributor
Forum|alt.badge.img+5
  • geo-xContributor
  • Contributor

Dear FME community.

I would like to duplicate lines who contains a specific character in a specific field and split the attribute of this field.

For example in this case I would like to duplicate and split the lines who contains the character * in the filed Field 3 and split it like that :

For begining I used a tester for make a filter on the Field 3 who contains the character *

Do you know how can I do that ?

Thank you.

Best answer by danilo_fme

Hi @lalandexavier

Please, see attachment the Workspace template:

 

Workspace template - Workspace_Duplicate.fmwt

 

 

 

Thanks,

Danilo

View original
Did this help you find an answer to your question?

3 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • danilo_fmeEvangelist
  • Evangelist
  • Best Answer
  • November 13, 2018

Hi @lalandexavier

Please, see attachment the Workspace template:

 

Workspace template - Workspace_Duplicate.fmwt

 

 

 

Thanks,

Danilo

mark2atsafe
Safer
Forum|alt.badge.img+44
  • mark2atsafeSafer
  • Safer
  • November 13, 2018

As @danilo_fme shows, you don't need to use a Tester. The AttributeSplitter will do what you need. If there is no special character then the attribute remains unsplit. Then use the ListExploder to turn the list of values into separate records.

geo-x
Contributor
Forum|alt.badge.img+5
  • geo-xContributor
  • Author
  • Contributor
  • November 14, 2018
danilo_fme wrote:

Hi @lalandexavier

Please, see attachment the Workspace template:

 

Workspace template - Workspace_Duplicate.fmwt

 

 

 

Thanks,

Danilo

Thank you very much @danilo_fme that's perfect !

Reply


Helpful Members This Week

Community Stats

31,320
Posts
118,826
Replies
38,953
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.