How can i convert data from Excel sheet (.csv file) to XML output? Has anybody done this before? If so can you share details on what stages you used and how you specified your XML tags etc. I appreciate your help.
Thanks
How to Convert data from excel to XML
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
The problem that you're going to have is reading the Excel Spreadsheet in UNIX. DataStage does not ship with an ODBC driver to read Excel in Unix. There are some other ways to do that, but not within DataStage.
You might check out this thread:
viewtopic.php?t=85601&highlight=read+ex ... sheet+unix
for more information.
Good luck,
Tony
You might check out this thread:
viewtopic.php?t=85601&highlight=read+ex ... sheet+unix
for more information.
Good luck,
Tony
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Thanks
Thanks Guys for the replies. I have .csv file only so i can put it out on Unix and can read it in my source file as an sequential file. However it is going to be a problem if that has comma or semi colen as a data. I am just going to seperate by tab. I will check the document chapter 4 for the details on XML. Let's see how far i can go.
Thanks again and share if you have other thoughts.
Thanks again and share if you have other thoughts.