Re^2: Perl csv insert with special character

Seriously getting someone else do my work will be the last thing in my mind. Spent half day resolving this then finally decided to get experts help.

I have typed each line here manually since I can't copy paste from my work laptop. Out of 500 codes of line I have written here what was relevant to my question. Code does work but somehow speical character gets ignore or something else. For which I though TEXT::CSV -> parameter and sample data will be more than enough.

Comment on Re^2: Perl csv insert with special character

Replies are listed 'Best First'.
Re^3: Perl csv insert with special character by Anonymous Monk on Dec 30, 2014 at 23:36 UTC
Now is a good time to step back and clean your room better :) Why? This `&insertRecords; sub insertRecords { my $fileToInsert = shift;` [download] Yes, I am xlink guy:) not other guy	[reply] [d/l]
Re^4: Perl csv insert with special character by homer4all (Acolyte) on Dec 30, 2014 at 23:46 UTC
insertRecords sub gets $file value from the main sub, since multiple file exist, I'm shift after each iteration. `&insertRecords ($file);` [download]	[reply] [d/l]
Re^5: Perl csv insert with special character by Anonymous Monk on Dec 31, 2014 at 02:57 UTC
insertRecords sub gets $file value from the main sub, since multiple file exist, I'm shift after each iteration. um, not in the code you posted at Perl csv insert with special character or code posted at http://stackoverflow.com/questions/27712706/perl-db-insert-with-special-character don't know how much it has to do with your problem, but a messy room like that makes me avoid looking closer at the question From your questions, either the csv isn't getting parsed correctly, or it isn't getting inserted ... two unrelated problems that are easy to debug independently Some tips for you text csv DBI sqlite complete compilable example.... no messy room (and related database specific optimization trick Loading bulk data into SQLIte magic speed incantation ) Some humor for you question + but its covered in tomato sauce ++ it comes from a jar +++ jam comes in jars too and tastes good on pancakes :D Yes, I am xlink guy:) not other guy, and its gusting 30mph around here	[reply]