Solved

Duplicate lines who contains a specific character

  • 13 November 2018
  • 3 replies
  • 2 views
G
Badge

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.

icon

Best answer by danilo_fme 13 November 2018, 18:56

View original

3 replies

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @lalandexavier

Please, see attachment the Workspace template:

 

Workspace template - Workspace_Duplicate.fmwt

 

 

 

Thanks,

Danilo

mark2atsafe
Rank
Userlevel 4
Badge +25

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.

G
Badge

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


Community Stats

28,729
Posts
109,526
Replies
36,564
Members
Terms & ConditionsCookie 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.