Skip to main content
Solved

Duplicate lines who contains a specific character

  • November 13, 2018
  • 3 replies
  • 19 views
geo-x
Supporter
Forum|alt.badge.img+6

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

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

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • Best Answer
  • November 13, 2018

Hi @lalandexavier

Please, see attachment the Workspace template:

 

Workspace template - Workspace_Duplicate.fmwt

 

 

 

Thanks,

Danilo

Partner Solutial Brazil - www.solutial.com.br
mark2atsafe
Safer
Forum|alt.badge.img+56
  • mark2atsafeSafer
  • Safer
  • 2554 replies
  • 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.

FME Evangelist to the Rich and Famous!!
geo-x
Supporter
Forum|alt.badge.img+6
  • geo-xSupporter
  • Author
  • Supporter
  • 89 replies
  • November 14, 2018

Hi @lalandexavier

Please, see attachment the Workspace template:

 

Workspace template - Workspace_Duplicate.fmwt

 

 

 

Thanks,

Danilo

Thank you very much @danilo_fme that's perfect !

Community Stats

32,084
Posts
121,834
Replies
39,720
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.