opening a file and parsing text

RaulJ

I have a file that is comma delimited. I want to open the file, read a line at a time, extract the 10 fields that are separated by commas in each line.

$myFile='ActiveVintageItems4.txt';
$fh=fopen($myFile,'r') or die("Can't Open file");
if ($fh) 
{
	while (!feof($fh)) 
	{
		$line = fgets($fh);
		//echo("line = " . $line . "</br>");
		$values =  explode(',', $line);
		$count = count($values);
		$valueString='';

		for ($i = 0; $i < $count; $i++)
		{
				$valueString = $values[$i] . ', ';
				echo($valueString . "= value string </br>");
		}

}

I get 10 fields like i am supposed to, but each field has this character ( � ) between every letter of every word in the field. The value below is supposed to be 1975.
1�9�7�5�

The file that I am working with was exported from SQL Server.

Thank you for any suggestions.

devinemke

i assume this is a CSV file? if you are using PHP 5.3.0 have a look at [man]str_getcsv[/man]. if not look at [man]fgetcsv[/man].

RaulJ

the fields are separated by commas but are not enclosed in quotes.

devinemke

$file = file('ActiveVintageItems4.txt');
foreach ($file as $value)
{
	$explode = explode(',', $value);
	foreach ($explode as $sub_value) {echo trim($sub_value) . '<br>';}
	echo '<hr>';
}

RaulJ

Thanks devinemke,

Much slicker way of doing it.
I am still getting the same character between each letter. I have to assume that the problem is in the way the file is produced from SQL Server. I will see what the options are.

Thanks again.

devinemke

open the file up in any text editor (notepad). do you see those extra character? you can always strip them out using [man]str_replace[/man].