importing csv into oracle

[Anon]

I am trying to import a large csv file into oracle and some of the fields have newline '\n' characters in them and it keeps complaining.

Even though I am spliting on ',' it interprets the '\n' as the end of the field in my insert statement.

Can anyone help?
Thanks in advance.

[znouza]

chop() function removes ending \n

[Anon]

I would also like to replace it so I can preserve the format when displaying it.

Here is the format of the data...

"1","3203","Lots of text with multiple"\n"
newlines and linefeeds","yes"

... etc.

here is what I use for the other csv files...

$fd = fopen("$filename", "r");
$x = 0;
while (!feof ($fd)) {
$buffer[$x] = fgets($fd, 4096); $x++;
}

foreach($buffer as $line) {
if($line != "") {
list($var1,$var2 = split (",", $line);
$sql = "insert ...."

This works fine as long as you can read the entire line and it has no newline or carriage returns in it.

[Anon]

Ok, I figured it out. Here is an explanation just in case someone wants to know...

First read the file and replace all "\n" with ~new~ or something unique.

Then urlencode the entire file and replace all %0A with ~lf~... or something unique.

Since it is urlencoded you could either split on %22%2c%22 or urldecode and split on ",". I chose to leave it urlencoded since I will be inserting it into a oracle table.

I also had to strip the leading and trailing quotation marks on each field and urldecode the integers, but it works.

Now, if I only knew of a more efficient way to insert a large amount of data into an oracle table... hmmm.