reading csv file

[qadeer_ahmad]

Hi,
I have read about fgetcsv but my problem is that i don't know my csv file is comma delimter or tab delimeter.
How can i handle this issue?

Thanks

[qadeer_ahmad]

one thing here if we access the type of csv i.e. it is tab or comma delimiters then this problem will solved.

[Weedpacket]

What do you know about the file? Is it likely to contain tab characters if it is comma-delimited? Is the first field of a recognisable format?

[qadeer_ahmad]

Thanks for reply
actually i am getting bad characters when i am reading tab delimiter csv file just like below

D�a�t�e� �C�h�a�n�n�e�l�

my code is very simple and below

// open the text file
		$fd_2 = fopen ("csv/AdSense-Report.csv", "r");
		// initialize a loop to go through each line of the file
		while (!feof ($fd_2)) 
		{
			// declare an array to hold all of the contents of each row, indexed
			$buffer_2 = fgetcsv($fd_2, 4096);
			// start a row for the table
			//echo "<tr>\n";
			// this for loop is the meat, the 44 represents the number of columns in
			//the text file, hey...the world is a hack!
			// when this is re-created with MySQL use the mysql_num_fileds() function
			//to get this number
			//for ($i_2 = 0; $i_2 < 43; ++$i_2){
			for ($i_2 = 0; $i_2 < 6; $i_2=$i_2+5)
			{
				$f0=trim($buffer_2[0]);
				$f0=sreplace($f0);

			$f1=trim($buffer_2[1]);
			$f1=sreplace($f1);

			$f2=trim($buffer_2[2]);
			$f2=sreplace($f2);

			$f3=trim($buffer_2[3]);
			$f3=sreplace($f3);

			$f4=trim($buffer_2[4]);
			$f4=sreplace($f4);

			$f5=trim($buffer_2[5]);
			$f5=sreplace($f5);
			$str=$f0."__".$f1."__".$f2."__".$f3."__".$f4;
			echo($str."<br>");
		}
		//echo "\n";//<strong>End of one row </strong><br>";

	}
	fclose ($fd_2);

its giving me out put of tab delimiter with wrong character (&#65533😉 if you have firefox you will see this character just like a question sign (?) in box.
but it give fine out put comma delimiter file

Thanks

[Weedpacket]

Actually, if you'd upgraded Firefox sometime in the past two months you'd see (&#65533😉 as a glyph indicating that it represents Unicode character u0FFFD, which is according to Unicode is officially called a "REPLACEMENT CHARACTER".

Me, I don't know why that's there (because I didn't create your data, and it doesn't look like you're using a character set I'm familiar with), but if it's there in tab-delimited data and not in comma-delimited data it's probably for the same reason that one is tab-delimited and the other is comma-delimited.

[qadeer_ahmad]

thanks
i got the solution i parse value with this function and now its ok. function is

function sreplace($string)
		{
		$stripped_body = str_replace("Ã", "", $string);
		$stripped_body = strip_tags($stripped_body);
		$stripped_body = htmlentities($stripped_body);
		$stripped_body = str_replace(" ", "", $stripped_body);
		$stripped_body = str_replace(" ", "", $stripped_body);
		$stripped_body = str_replace("â", "â", $stripped_body);
		$stripped_body = str_replace("¢", "¢", $stripped_body);
		$stripped_body = str_replace("ó", "ó", $stripped_body);
		$stripped_body = str_replace("é", "é", $stripped_body);
		$stripped_body = str_replace("á", "á", $stripped_body);
		$stripped_body = str_replace("ñ", "ñ", $stripped_body);
		$stripped_body = urldecode(str_replace("%EF%BF%BD", "", urlencode($stripped_body)));
		$stripped_body = str_replace("£", "£", $stripped_body);
		return $stripped_body;
		}

Thanks for replying.