Recent content by perlnoob

I'm not sure there is a "uid" value... there are "guid" and "sid". The guid is a 128 bit binary number that uniquely identifies (across the entire domain and all OU's) an object such as a computer or person. If that is what you are looking for, you will have to change that number from a...

Muchas gracias! Looks like you're looking at each individual character, and filtering that way. Awesome approach, thanks for the tip!

I just did some more data mining, and found another "problem" with my cells... here is the example line: cell1,""ce"ll2""","cell,3",cell4....cellx Some cells have more than one "pair" of double quotes.... So I have a variable number of double quotes per cell now...sheesh So...

Thanks, I'll give that a try! Also, about my last post, I meant "can't" do, not can..oops. Sorry about that, but thanks for the reply. Also, is that module on CPAN?

I know about SQL Loader, and have tried it already, but there are limitations that it can do when I load the data, such as joining queries, doing look ups, storing temp variables for calculations, etc.... thanks,

hey all, Situation: 1. A file comes in a .csv format (I have no control on that part). 2.Cells need to be parsed out for DBI module load into database 3.Cell Data looks like this: col1,col2,col3....colx I use a while loop, and split function to assign each row a variable for the loop for...