Re: Comma concatenation for all unique node value base

Hi ,
Is there anyway I could select all the unique PRODUCT_NUMBER with
their sibling node CUST_MSG=Y in a for loop so that i can concatenate
comma.if it is more than one .
Please help me this .
Thanks,
Senthil
On 3/29/07, Senthilkumaravelan K <skumaravelan@xxxxxxxxxxxxxx> wrote:

Hi
<LINE_ITEMS>
<LINE_ITEM>
<PRODUCT_NUMBER>1</PRODUCT_NUMBER>
<CUST_MSG>Y</CUST_MSG>
</LINE_ITEM>
<LINE_ITEM>
<PRODUCT_NUMBER>1</PRODUCT_NUMBER>
<CUST_MSG>Y</CUST_MSG>
</LINE_ITEM>
<LINE_ITEM>
<PRODUCT_NUMBER>1</PRODUCT_NUMBER>
<CUST_MSG>Y</CUST_MSG>
</LINE_ITEM>
<LINE_ITEM>
<PRODUCT_NUMBER>2</PRODUCT_NUMBER>
<CUST_MSG>N</CUST_MSG>
</LINE_ITEM>
</LINE_ITEMS>

My expected out is
<products>1 and 2.
depends on the CUST_MSG value I need to concatenate "," and respectively.

Thanks,
Senthil