Re^7: Pre-process csv files before using

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;
[download]

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!

Comment on Re^7: Pre-process csv files before using Select or Download Code

Replies are listed 'Best First'.
Re^8: Pre-process csv files before using by DrAxeman (Scribe) on Aug 06, 2005 at 20:22 UTC
This is a small sample of the header data `PDHCSV40EasternDaylightTime240,ERWWCOMMUNITIES.MemoryPagesPERsec,ERWWC +OMMUNITIESNetworkInterfaceEthernetAdapterModuleBytesTotalPERsec,ERWWC +OMMUNITIESNetworkInterfaceEthernetAdapterCurrentBandwidth` [download] 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)	[reply] [d/l]

Replies are listed 'Best First'.

Re^8: Pre-process csv files before using
by DrAxeman (Scribe) on Aug 06, 2005 at 20:22 UTC

PDHCSV40EasternDaylightTime240,ERWWCOMMUNITIES.MemoryPagesPERsec,ERWWC
+OMMUNITIESNetworkInterfaceEthernetAdapterModuleBytesTotalPERsec,ERWWC
+OMMUNITIESNetworkInterfaceEthernetAdapterCurrentBandwidth
[download]

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

[reply]
[d/l]