CSV files, but how about the comma already in the value?

[searain]

CSV (comma separated values) files are used in tranfer data between the platforms.

But if the value itself has comma, how do we handle that?

Thanks!

[diego25]

I think the entire string is placed within quotes.

e.g.

1,value,other value, "one, two, and three values"

You can test it. Open Excel or some other spreadsheet program, type in stuff in the fields and export it as a CSV file. Then open the CSV file in notepad to see how they do it.

Diego

[searain]

Thanks, guys.

Any CSV files handling links. scripts you can suggest?

I am in a big hurry to grab one instead of writting my own.

Thanks.

[searain]

diego, thanks, yes it is included in " " if there is , in the value.

could anyone help me with a script of handling csv files?

thanks.

[Matt_Parsons]

I have just been doing something similar. This works for me:

<?
include("sql.php");
mysql_connect($hostname,$username,$tbpassword) or DIE("DATABASE FAILED TO RESPOND.");
mysql_select_db($dbName) or DIE("Database unavailable");

$result = mysql_query("select * from table");
$content =("Club Name, Link, Description\n");
while($row = mysql_fetch_array($result))
{
$q_mark="\"";
$club = $row["clubname"];
$link = $row["link"];
$des = $row["description"];
$des=$q_mark. $des . $q_mark;
$content = $content. $club ."," .$link .",".$des;
$content = $content. "\r";
}

header("Content-type: application/octetstream");
header("Content-disposition: filename=test.csv");

echo $content;
?>