Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^6: Pre-process csv files before using

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


in reply to Re^5: Pre-process csv files before using
in thread Pre-process csv files before using

I'm getting an odd error with this

shift @origcols; foreach ( @origcols ) { $_ =~ s/\.//; push ( @cols , $_ ) unless /Bandwidth.*|MSTCPLoop.*/ ; }

It says:
Use of uninitialized value in substitution (s///) at ./runsql3.sql lin +e 20. Use of uninitialized value in pattern match (m//) at ./runsql3.sql lin +e 21.
Line 20 is my "s/\.//" line


Comment on Re^6: Pre-process csv files before using
Select or Download Code
Re^7: Pre-process csv files before using
by sk (Curate) on Aug 06, 2005 at 20:11 UTC
    I would check if there are proper values in your @origcols array.

    Do something like this before you get into the loop to modify it

    map { print $_,$/ } @origcols;
    If you see proper output then need to look at other places. Example of your header data will be helpful!

    Actually davidrw's grep solution is much cleaner!

      This is a small sample of the header data

      PDHCSV40EasternDaylightTime240,ERWWCOMMUNITIES.MemoryPagesPERsec,ERWWC +OMMUNITIESNetworkInterfaceEthernetAdapterModuleBytesTotalPERsec,ERWWC +OMMUNITIESNetworkInterfaceEthernetAdapterCurrentBandwidth

      In the original data, some of the headers have periods in them. This causes SQL error, so I've been stripping them in a preprocessing program. I'm trying to stream line this, and get rid of the preprocessor.

      To test this I've been adding a period in one of the fields. Thats when I get the error. I have inserted a period in the second header value to simulate what I am trying to strip.

      20050807 Janitored by Corion: Made page-widening code wrap (only multiline code wraps)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (11)
As of 2014-09-23 19:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (239 votes), past polls