Posted by Philip Hallstrom on 09/07/05 23:23

> Hello All,
>
> I'm having some issues with carriage returns. Specifically the control M
> character (^M). I have attempted to clean and validate the file I'm
> creating. Here's the code.
>
> while ($row = mysql_fetch_array($result)){
>
> // assign and clean vars
> $artist = trim($row[artist]);
> $tdDate = trim($row[start_date]);
> $venue = trim($row[venue]);
> $city = trim($row[CITY]);
> $state = trim($row[STATE]);
> $country = trim($row[COUNTRY]);
> $tdId = trim($row[td_id]);
>
> // create string
>
> $line = "$artist|||$tdDate||$venue|$city|$state|$country|$tdId\n";
>
> // validate the string
>
> if(preg_match("/.*.|||.*.||.*.|.*.|.*.|.*.|.*.n\//", $line)){
> // record is correct so write line to file
> fwrite($handle,$line);
> }
> }
>
>
> So ^M slips right by trim and my preg_match line.

Where is the carriage return appearing in your line of output? Trim
will remove these, but only at the beginning/end of a string so if $artist
= "Paul\rNowosielski" that won't get cleaned up...

Maybe run them through ereg_replace() using "[\n\r]" as a pattern?

-philip

[Back to original message]