Extracting multiple occurences in XML file

cosec · Post by **cosec** » Tue Mar 01, 2011 2:49 am

I have an xml file with repeated info such as the following.

example:

<PRODUCT_INFO>
<PROD_CD>PROD_CD1</PROD_CD>
<PRODUCT_INFO>
<PRODUCT_INFO>
<PROD_CD>PROD_CD2</PROD_CD>
<PRODUCT_INFO>

I am required to store the first occurence (i.e. PROD_CD1) under a Field A and the second occurence (i.e. PROD_CD2) under a Field B.

I am able to extract the value for the first occurence. However unable to retrieve the second occurence. Please advice. Thanks.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 01, 2011 4:34 am

Set up a stage variable to report whether you've already seen the opening PROD_CD tag - if you have, transfer the value to the second field; if you haven't, transfer the value to the first field.

Sreenivasulu · Post by **Sreenivasulu** » Tue Mar 01, 2011 5:28 am

One question:
Any idea why the 'product_info' tag is not 'ending' ?

ray.wurlod · Post by **ray.wurlod** » Tue Mar 01, 2011 3:26 pm

Probably because cosec forgot to type the / characters!