Hi,
I need to extract <APPNUMBER> tag alone, if the <college> haas IIT Chennai value. college tag value will have spaces embedded. Those spaces should not be suppresses.
My Source file
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><college>IIT Chennai </college>
<details>
<interviewheldby>Raja</<interviewheldby>
<courseopted>MSC</courseopted>
<Regno>742</Regno>
<BuildingName>Rajvilas</BuildingName>
<CustomerClass>B</CustomerClass>
<Appnumber>3018369</Appnumber>
<Date>21/05/2010 06:04:22</Date>
<PostalOutcode>N8</PostalOutcode>
<PostalIncode>9SJ</PostalIncode>
</details>
</Record>
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><placeofbirth>chennai mylapore </placeofbirth><dateofbirth>22ndmay99</dateofbirth><college>IIT Chennai </college><course>MCA</course>
<details>
<interviewheldby>Suresh</<interviewheldby>
<courseopted>MSC</courseopted>
<Regno>742</Regno>
<BuildingName>Rajvilas</BuildingName>
<CustomerClass>B</CustomerClass>
<Date>21/05/2010 06:04:22</Date>
<Appnumber>3018370</Appnumber>
<PostalOutcode>N8</PostalOutcode>
<PostalIncode>9SJ</PostalIncode>
</details>
</Record>
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><placeofbirth>chennai mylapore </placeofbirth><dateofbirth>22ndmay99</dateofbirth><college>IIT Mumbai </college><course>MCA</course>
<details>
<interviewheldby>Suresh</<interviewheldby>
<courseopted>MSC</courseopted>
<Regno>742</Regno>
<BuildingName>Rajvilas</BuildingName>
<CustomerClass>B</CustomerClass>
<Appnumber>3018370</Appnumber>
<Date>21/05/2010 06:04:22</Date>
<PostalOutcode>N8</PostalOutcode>
<PostalIncode>9SJ</PostalIncode>
<Appnumber>3018370</Appnumber>
</details>
</Record>
Please guide me.