Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re^12: Database processing

by DrAxeman (Beadle)
on Aug 06, 2005 at 17:13 UTC ( #481521=note: print w/ replies, xml ) Need Help??

in reply to Re^11: Database processing
in thread DBI::st=HASH output

This is great! One more question.

Part of my "pre-processing" requires me to open the csv files in OpenOffice. I'd like to eliminate this piece. The major piece of this is making sure the data is converted into decimal. There is a module Data::Types that will allow me to conver to decimal. See

I'm not sure how to write the loop that will convert all the data into decimal.

I'd also like to be able to delete some columns that are not needed, like the first one, and any that's header contains MSTCPLoopback, or columns whose header ends with Bandwidth.

I am trying to use the ALTER statement but it's not found. Or would it be better to just skip the columns while we are processing them?

Comment on Re^12: Database processing
Replies are listed 'Best First'.
Re^13: Database processing
by davidrw (Prior) on Aug 06, 2005 at 19:27 UTC

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://481521]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2015-11-29 07:21 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (748 votes), past polls