Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

jonasbn (1153)

jonasbn
  reversethis-{gro.napc} {ta} {nbsanoj}
http://e-diot.dk/
AOL IM: BJonasN (Add Buddy, Send Message)

Perl Programmer located in Copenhagen, Denmark. Active member of Copenhagen Perl Mongers.

Author of:

  • Business::DK::CPR
  • Business::DK::CVR
  • Business::DK::PO
  • Business::OnlinePayment::CashCow
  • Date::Holidays
  • Date::Holidays::Abstract
  • Date::Holidays::Super
  • Date::Pregnancy
  • Games::Bingo
  • Games::Bingo::Bot
  • Games::Bingo::Print
  • Module::Info::File
  • Module::Template::Setup
  • Test::Timer

and maintainer of:

  • Tie::Tools
  • XML::Conf
  • Workflow

Journal of jonasbn (1153)

Wednesday December 03, 2003
03:08 PM

Perl Stuffing

[ #16149 ]

We got a difficult database extraction task today. Extracting a lot of log data from a table and combining it with a colletion of translations of some of the data in the log, a kind of multilanguage setup used by the VB.NET frontend.

Well here my SQL abilities come a bit short and in with combination of time constraints and work pressure - I made a Perl solution.

First I extracted the necessary data from the multilanguage table and then I ran the translation proces on the extracted log data and finally I pushed everything into a CSV file.

WOA! lucky for me I know Perl, I could simply fill in the gaps with Perl and everything works great.

I am sure I would be able to make the solution in SQL (eventually), but I am glad I chose the Perl solution, since it also had a very positive effect on my morale :)

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.