re:convert database(text file) to xml


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: re:convert database(text file) to xml

  1. #1
    Alvin Guest

    re:convert database(text file) to xml


    hi , i have a problem of doing conversion between text file (export form db2)
    into xml file ...i need guide ...thks!

  2. #2
    Russell Jones Guest

    Re: re:convert database(text file) to xml

    This might help:
    Kurt Cagle's: Converting Fixed-Width Text Records to XML
    http://gethelp.devx.com/techtips/xml...kc060501-1.asp

    "Alvin" <cks8829@yahoo.com> wrote in message
    news:3bc59952$1@news.devx.com...
    >
    > hi , i have a problem of doing conversion between text file (export form

    db2)
    > into xml file ...i need guide ...thks!




  3. #3
    Matt Hendryx Guest

    Re: re:convert database(text file) to xml


    "Alvin" asked about converting databases to xml. My "dirty" method has worked
    quite well on a number of occassions. In my teaching environment most of
    my documents are in Excel or some sort of .csv format. I have created a
    spreadsheet in both Excel and in OpenOffice's scal that has worksheet one
    as the import sheet for the data. Worksheet two spreads the data into every
    other column. Then the top of each blank column on sheet 2 has the xml code
    (usually the closing tag for the previous column and the start tag for the
    next) entered. Copy these down the columns. Now copy this second sheet
    and "paste special" and click "values" onto a third worksheet. Export this
    third sheet as a txt or .csv file and you have an xml data base file. If
    you do it in OpenOffice, you can specify the field delimiters to be empty.
    This saves any touch up editing after you export the third worksheet.

    In particular this technique works well if you want to convert your emails
    to your own xml format. Export the folder as a .csv format, then bring into
    OpenOffice and go through the conversion above.


    "Russell Jones" <arj1@northstate.net> wrote:
    >This might help:
    >Kurt Cagle's: Converting Fixed-Width Text Records to XML
    >http://gethelp.devx.com/techtips/xml...kc060501-1.asp
    >
    >"Alvin" <cks8829@yahoo.com> wrote in message
    >news:3bc59952$1@news.devx.com...
    >>
    >> hi , i have a problem of doing conversion between text file (export form

    >db2)
    >> into xml file ...i need guide ...thks!

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center