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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.