Add Slashes

[iceblox]

Hi All,

 

I have a script which uploads a CSV feed, the issue is that the feed text contains commas. I have been told the best way to do this is to add slashes?

 

How would i add this to my script. This is line i believe it needs to be added too.

 

$cols = explode(',', trim($line));

 

Thanks in advance

[Barand]

Either use a delimiter other than comma in the CSV

[pre]

1|field2|text,with comma|more text

[/pre]

 

or enclose text items in ".."

 

[pre]

1,"field2","text,with comma","more text"

[/pre]

 

EDIT: Nearly forgot, use fgetcsv() to read the data, not explode, then you can specify the delimiter and quotes

[iceblox]

Thanks for that Barrand,

 

All sorted ;0)

 

One more for you if you dont mind..

 

The script i have replaces data in the feed for a a number which is defind within the feed. I was told that if there was a string i wanted to replace i could do this for example..

 

 

If I have "http://www.url.com/id=xxxx"

 

and i want to replace "xxxx" for "4444" i was told to do this "xxxx|1" => "4444"

 

But this isnt working. Any ideas?

[Barand]

$str = str_replace ('xxxx', '4444', "http://www.url.com/id=xxxx");

[iceblox]

Does the http://www.url.com/id=xxxx bit have to match exactly for it to work?

 

As mine is a data feed the bit after that in the same url is constantly changing?

 

 

Thanks for the help

[Barand]

the "xxxx" needs to match

[iceblox]

Hmm,

 

So i added this to my array,

 

 

'!!!id!!!', '52297', "http://www.awin1.com/awclick.php?mid=2040&id=!!!id!!!");

 

but this is what it is doing to my url..

 

 

http://www.awin1.com/awclick.php?mid=2!!!id!!!4!!!id!!!&id=!!!id!!!

 

Am I doing something wrong?

[iceblox]

Any ideas? Anyone?