in reply to Re^3: Unable to load entire CSV file into DB
in thread Unable to load entire CSV file into DB

Great suggestion, I've written this in as one more safeguard. However, I don't understand all that I'm seeing when I check for ascii or hex values. Here's a dump of a file that looks like this:

,AL,2 ,AK,4

in ascii

A--65 L--76 ,--44 2--50 --13 ,--44 A--65 K--75 ,--44 4--52 --13

What is the blank spot? Even if it's a new line, shouldn't it have a value? Just curious.


—Brad
"Don't ever take a fence down until you know the reason it was put up." G. K. Chesterton

Replies are listed 'Best First'.
Re^5: Unable to load entire CSV file into DB
by steves (Curate) on Nov 07, 2004 at 13:10 UTC

    It's printing the value, which is a newline, then showing its numeric (decimal) value. So you see the newline, which shows up as a blank line, then the 13. 13 is a CR.

      Of course! I get it, thanks.


      —Brad
      "Don't ever take a fence down until you know the reason it was put up." G. K. Chesterton