File Content Conversion

Hi All,

Please help with the file content conversion scenario described below:

<u>Source File Format</u>

"A",10,TEST,38

"B",10,ABC,56

"C",87,DEF,76

"B",898,XYZ,798

"C",845,UVW,78

"B",8123,YTE,908

"C",67,TYI,789

<u>Source Structure</u>

<A>

<NAME>"A"</NAME>

<VAL1>10</VAL1>

<VAL2>TEST</VAL2>

<VAL3>38</VAL3>

</A>

<B>

<NAME>"B"</NAME>

<VAL1>10</VAL1>

<VAL2>ABC</VAL2>

<VAL3>56</VAL3>

</B>

<C>

<NAME>"C"</NAME>

<VAL1>87</VAL1>

<VAL2>DEF</VAL2>

<VAL3>76</VAL3>

</C>

<B>

<NAME>"B"</NAME>

<VAL1>898</VAL1>

<VAL2>XYZ</VAL2>

<VAL3>798</VAL3>

</B>

<C>

<NAME>"C"</NAME>

<VAL1>845</VAL1>

<VAL2>UVW</VAL2>

<VAL3>78</VAL3>

</C>

In the Recordset Structure if specify <b>A,1,B,,C,</b>

only the first three records get picked up i.e. i have an output in the format <A></A><B></B><C></C>. Rest of the records are not getting picked up.

Please help me with the content conversion parameters that need to be specified.

Regards

Sidharth