Menu
Community /Pin to ProfileBookmark
@NogDogOct 25.2006 — #Not sure if this is what you're after, but a CSV field can have commas within it, as long as the entire field is quoted. For example, this would be treated as 3 fields, not 5, as the quoted section would be treated as one field:
@NogDogOct 25.2006 — #fputcsv() will automatically handle the quoting of fields which contain commas.
@NogDogOct 25.2006 — #I just double-checked, and fputcsv() is PHP5, so you might still want to stick with your custom function if you want your code to be more portable. @NogDogOct 25.2006 — #Note to "raj", you can use implode() to easily create a tab-delimited file:
@NogDogOct 25.2006 — #
Note that in this case, since you are conditionally defining a function, this definition must appear in your code before you call the function.
tab delimiter in csv file
Hi all
I have posted similar type thread previously but now i want to know some thing more about the tab delimiter.
I have few records in the mysql db and i am exporting those records through a csv file in excel format.
My question:
1.Cant i use tab as a delimiter while exporting the records in a csv file?
say,
I have these records
Name age products
A 34 B,C,D
E 35 F,G,H
Now these commas(B,C,D) will be stay in the excel file but will be separated by a tab………..How is it possible?
My php code is here:
[code=php]$file_pointer = fopen(“sample.csv”, “w”);
fwrite($file_pointer,””);
fwrite($file_pointer,$string);
fclose($file_pointer);
$file_pointer=fopen(“sample.csv”, “w”);
fwrite($file_pointer,”ICODE,STK,POC,BOCC,BOCU,TYPE,DESIGN,D1,D2,HT1,HT2,LIST,CIDn”);//shall i use tab here if so then how?
$sql_email =”select * from product where cid='{$_GET[‘cid’]}'”;
$result=mysql_query($sql_email);
while($row=mysql_fetch_array($result))
{
//data fetch
fwrite($file_pointer,”$icode,$stk,$poc,$bocc,$bocu,$type,$design,$d1,$d2,$ht1,$ht2,$list,$cidn”);
}
fwrite($file_pointer,$string);
fclose($file_pointer);
header(“location:download.php?file=$cname.txt”);
Please suggest me how to proceed,
Thanks in advance
Raj
Sign in
to post a comment12 Comments(s) ↴
0
@NogDogOct 25.2006 — #Not sure if this is what you're after, but a CSV field can have commas within it, as long as the entire field is quoted. For example, this would be treated as 3 fields, not 5, as the quoted section would be treated as one field:<i>
</i>field1,field2,"this,is,field3"
0
@NogDogOct 25.2006 — #fputcsv() will automatically handle the quoting of fields which contain commas.[code=php]
$result = mysql_query($sql); // where $sql is your query
$fh = fopen('output.csv', 'w')
while($row = mysql_fetch_array($result))
{
fputcsv($fh, $row);
}
fclose($fh)
// view the results:
$output = file_get_contents('output.csv');
echo "<pre>$output</pre>n";
[/code]0
@NogDogOct 25.2006 — #0
@NogDogOct 25.2006 — #Note to "raj", you can use implode() to easily create a tab-delimited file:[code=php]
$fh = fopen('tabbed.txt', 'w');
while($row = mysql_fetch_array($queryResult))
{
fwrite($fh, implode("t", $row));
}
fclose($fh);
[/code]0
@NogDogOct 25.2006 — #That brings to mind a question I've had about PHP (which PHP is only a recent, as of two years, addition to my programming languages repertoire). Please forgive a short hijacking. But...
Can I test for the existence of a particular intrinsic function and only instantiate my custom function in the case that the intrinsic function does not exist?[/QUOTE]
[code=php]
if(!function_exists("some_function"))
{
function some_function()
{
// function definition
}
}
[/code]Note that in this case, since you are conditionally defining a function, this definition must appear in your code before you call the function.