It sounds like a perfect project to learn Perl with. You can do what you want in well under thirty lines of code. You don't mention if you know *any* languages. If you do you can learn enough Perl to do it very quickly. If you don't it will take a little longer to wrap you head around the basic programming concepts but you should still be able to easily achieve your goal.

The recommended book for learning Perl is called....wait for it....Learning Perl by our own merlyn and would be a good place to start. The payoff is a very versatile tool that would let you actually do something with that data once you have it in the database ;-)

If you don't want to learn Perl there are plenty of monks here who could write it for you (for a fee) but then you would miss a lot of fun. If you put in a little effort you will find that we will be happy to help with any problems you strike along the way.

cheers

tachyon

s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print

In reply to Re: Importing into Database by tachyon
in thread Importing into Database by aszl826

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.