Use the StringSearcher. Params e.g.

Expression:

^(.*?)_(.*?)_.*?_(\d{5})_(.*?)_

Advanced > Subexpression Matches List Name:

listname

Test it and have a look at the list listname.

hmmm…..list was created but not right…….. fme_feature_type is the attribute to split

listname 0 is ok
listname 1 also ok
listname 2 should be Fliessgewaesser……….here in this case is only one word between second underscore and the 5 digit number (but there could also be 3 or 4 words)

listname 3 should be 20240 (is now listname 3)
listname 4 should be  AGE (is now listname 4) and so on

but we are on the way

Cheers

Franco

I see, you change your post.

My answer is an example. The work is your part.

I would avoid intricate RegEx expressions. They are hard to debug and they do not work the same in every environment.

I have solved this using the following native tools:

• AttributeSplitter splits attribute and puts every part between the underscores in a list item.
• ListSearcher searches the list using RegEx for 5 digits and returns 5_digit_number_index.
• ListExploder explodes list.
• Tester filters out the first two elements (index 0 and 1) and all the elements that share the same index or higher as the 5_digit_number_index.
• Aggregator (grouped by ID) aggregates all list features together and creates a new list (Generate List: z_list).
• Finally the ListConcatenator creates the output string of all string elements between the first two elements and the 5 digit number.

 

i know that this is only an example……..but i would need the part “gemischte_industrie_gewerbe_flaechen” also together in one list attribute

I would avoid intricate RegEx expressions. They are hard to debug and they do not work the same in every environment.

I have solved this using the following native tools:

• AttributeSplitter splits attribute and puts every part between the underscores in a list item.
• ListSearcher searches the list using RegEx for 5 digits and returns 5_digit_number_index.
• ListExploder explodes list.
• Tester filters out the first two elements (index 0 and 1) and all the elements that share the same index or higher as the 5_digit_number_index.
• Aggregator (grouped by ID) aggregates all list features together and creates a new list (Generate List: z_list).
• Finally the ListConcatenator creates the output string of all string elements between the first two elements and the 5 digit number.

 

That do the work for me….thank you….but the listconcatenator is not necessary because to concatenate the attributes inside the aggregator also do the work

thx a lot and cheers

Franco