having trouble making data csv safe

[kts]

In the description field, I have bullets and such. I have used strip_tags and other methods of replace to remove this, but it continues happening. Has anyone had any similar problems that they have solved?

 

Shows up like

O  Blah blah blah

O  Blah blah blah

 

Thanks!

[gevans]

Can you give us some code and explain a bit better, I'm not totally sure what you get and what you expect to get

[omfgthezerg]

Try preg_replace?

 

$string = preg_replace('/[^\w\d]/', '', $string);

 

Note: This is a very aggressive replace and will replace anything that is not a word and not a number.

[gevans]

Try preg_replace?

 

$string = preg_replace('/[^\w\d]/', '', $string);

 

Note: This is a very aggressive replace and will replace anything that is not a word and not a number.

 

It also takes a lot longer than the standard string replace methods and is a last resort in standard cases (personally)

[kts]

it has gotten quite messy, been pulling out all stops haha

 

 

function csvsafe($str=''){
return '"'.trim(str_replace('"','\'',$str)).'"';  
}

$description = ''.strip_tags(csvsafe(strip_tags(str_replace(chr(13)," ",str_replace(chr(10)," ",($desc['value']))))));
$data .= str_replace($search, $replace, $description).','; 

[gevans]

Can you give me an example of input text and the expected output text?

[kts]

Sorry for the delay found out more the actual text is this

 

Product Features:

O	Piston-driven Microprocessor

O	Adjustable Speed Settings

O	Adjustable Suction Knobs From 0 - 250 MmHg.

O	Built-in Bottle Holders

O	Breast Pump

O	Includes 12 V Car Adapter, Hospital Grade Cord

O	Designed For Medical Facilities Or Moms Of Twins

 

and that is how it is coming out, im trying to remove the O          etc etc etc and just make it plain text friendly

 

[gevans]

And do you have an example of your CSV file?

[kts]

its a rather large file, but that is literally the pasted out..

 

the situation is i need this to be able to be just flat text for an import

[gevans]

oh sorry, that's how it looks in the file, if it's standard like that why not just not print the first 4 characters

 

echo substr($your-line, 4);