Thanks again for the overwhelming response every one.
Hmm, there's so many different ways to do this. I'm
sorry that I didn't provide more details about my
programming/script languages background, in my
original post.
I knew a little bit of VB, but have forgotton it now,
and I can't run AWK script on WindowsXP I guess.
From your responses it occured to me that I could
write a Java program to convert from a CSV to XML.
-Many thanks
Rashmi
--- Iñaki Arrieta Baro <zerrendak(_dot_)iabaro(_at_)gmail(_dot_)com>
wrote:
- Save your file in .csv (Comma-separated values)
format using pipe
like field separator carachter. You can do this with
any spreadsheet.
- Apply this AWK script:
BEGIN{<books>;FS="\|"}
{printf("<book>\n\t<isbn>%s</isbn>\n\t<title>%s</title>\n</book>\n\n",$1,$2)}
END{</books>}
Iñaki
On 10/4/06, Rashmi Rubdi
<dev_subscriptions(_at_)yahoo(_dot_)com> wrote:
I am looking for an easy way to create an XML data
file.
For example I have my xml data structure like
this:
<books>
<book>
<isbn>1234</isbn>
<title></title>
</book>
<book>
<isbn>1234</isbn>
<title></title>
</book>
</books>
It's a bit tedious to create this file manually
and
was looking to enter the data in an Excel spread
sheet
and then use a converter to convert from Excel to
XML.
Does any one know a good converter?
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Iñaki Arrieta Baro
http://www.dokulan.net
Dokumentazioaren inguruko berriak euskaraz
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--~------------------------------------------------------------------
XSL-List info and archive:
http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to:
http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--