I have a query(MyQuery) which gets the following, need
help in writing
code to convert them to the below structure and saving
as text file. Is
this possible? Any help would be highly appreciated.
Thanks,
Sujith
Query:
Name A B C
ASD 20 11 1-Jan-05
BSD 20 5 2-Jan-05
CSD 0 0 3-Jan-05
EFD 20 3 4-Jan-05
GFD 10 22 5-Jan-05
Required Structure on text file:
<data>
<variable name = "MyQuery" >
<row>
<column>Name</column>
<column>A</column>
<column>B</column>
<column>C</column>
</row>
<row>
<column>ASD</column>
<column>20 </column>
<column>11 </column>
<column>01 Jan 05</column>
</row>
<row>
<column>BSD</column>
<column>20 </column>
<column>5 </column>
<column>02 Jan 05</column>
</row>
<row>
<column>CSD</column>
<column>0 </column>
<column>0 </column>
<column>03 Jan 05</column>
</row>
<row>
<column>EFD</column>
<column>20 </column>
<column>3 </column>
<column>04 Jan 05</column>
</row>
<row>
<column>GFD</column>
<column>10 </column>
<column>22 </column>
<column>05 Jan 05</column>
</row>
</variable>
</data>
__________________________________________
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
