Sorry. Should have said. The rrrrr above should read BLUE

Hello,

The FMEs version of "split text to rows" is the AttributeSplitter followed by a list exploder, same question: https://knowledge.safe.com/questions/35589/split-a-row-into-multiple-rows-by-a-field-with-del.html

The last part he's doing with the multi row formula is basically the FMEs Counter:

I'm stuck on the last part with the color "BLUE". You would have to parse it out somehow, brain freeze...

Hi @fordy,

This is definitely possible to do in FME. As @davidrasner5 mentions, you will likely have to work with some lists, the AttributeSplitter and the ListExploder being helpful transformers in this process.

Here are some of the steps to get the workflow you're looking for:

1. I read in the line as a textfile in the TextFile reader

2. Used an HTMLExtractor to grab the coordinates and the colour values. For me, setting up this transformer correctly was probably the hardest part (thanks @debbiatsafe!)

    

   

3. Since we grab those as List Attributes, we want to explode the list into attributes in our table by using the AttributeExploder on the coordinates. I use a second AttributeExploder for the colour

4. Next, I use an AttributeSplitter on the coordinates list with the delimiter set to ', ' or 'comma+space' which creates a new list of coordinate pairs. I have named it _coords

5. Explode this list (_coords) into attributes.

6. What's left now is to concatenate it in the format you want. I did this using a StringReplacer and a StringConcatenator. My output looks like this:

    

   

My final workspace then looks like this: