Child attributes into one field

i have a xml like this:

<products>
    <properties>
        <prop>
            <property>Color</property>
            <values>
                <value>
                    <title>Red</title>
                </value>
                <value>
                    <title>Green</title>
                </value>
            </values>
        </prop>
        <prop>
            <property>Length</property>
            <values>
                <value>
                    <title>10</title>
                </value>
                <value>
                    <title>20</title>
                </value>
            </values>
        </prop>
    </properties>
</products>

I am trying to put the colors into one field seperated in comma like this:
Red, Green

Some products have one color and some more, how can i achieve this?

• This topic was modified 4 years, 8 months ago by celik75.
• This topic was modified 4 years, 8 months ago by celik75.