html and other code in table problem

[clay1]

I am writing a script to export a table to excel for a client

 

They have a column 'more_info' that they have brilliantly included html and javascript in. This is breaking the file when it's exported. Works fine until it hits the html and then the

<br>

screws up the rest of the file.

 

I tried strip_tags but got the same result

 

while($row_DetailRS1 = mysql_fetch_array($DetailRS1)){

		for($i=0; $i< count($row_DetailRS1); $i++){
			echo strip_tags($row_DetailRS1[$i]);

			if($i == count($row_DetailRS1)){

				echo "\r";
			}
			else {echo "\t";}
		}

 

I suspect strip_tags won't work on an array?

 

Ideas to fix this besides telling the client to get rid of the offending characters..?

[clay1]

Or is this a problem more with my spreadsheet program? I'm using openoffice.org

 

Is the php doing everything correctly but when I open the spreadsheet it's reading the html?

[clay1]

Help?

[clay1]

Maybe Monday morning will get a response?

[travis]

have you tried str_replace

$row_DetailRS1[$i] = str_replace("<br>", "", $row_DetailRS1[$i]);

?

[clay1]

I did this:

 

$field = $row_DetailsRS1[$i];
$cleanfield = strip_tags($field);

 

The html is removed when I just print to the screen.

 

However the xls file is still borked. I emptied the field that was causing the problem and that row printed out fine.

 

Then I removed the column altogether(I am using a copy of the table to test with) and the xls file only had 1 row.

 

Very perplexing

[clay1]

OK. I've narrowed this down a bit I think. The problem being quotes in the html field.

 

I am exporting to CSV now and this is what I am getting on a screen dump:

 

http://,url"
Click here .
\"

 

The URL is getting broken up into separate fields.

 

The field in the table has both single and double quotes in it. How can I force those to be ignored?

[clay1]

Changing my separator to \t and my encloser to ` fixed it-- is this my best solution?