How to show your script output as it is producing it. Normally everything is buffered and shown all at once, but sometimes you want to show the actual progress of the script.
Continue reading php ob_flush
This needs a few steps to get it working.
You want a CSV, a comma-separated file, to actually have comma’s as separators and NOT semi-colons as your field delimiter!
However, in countries where the comma is used as decimal separator, this is not by default for Excel. Various sources hint to the solution, but none are really complete. You need to do this:
1. Change the system – region settings – additional settings – to use a , as list separator.
Continue reading Excel CSV with comma’s
2. Change Excel – options – advanced – to not “Use system separators”, but manually set a . as Decimal separator and , as Thousands separator.
3. Then with Excel, save your file as “CSV (Comma Delimited)”
4. Change your Excel setting back to what it was (Use system separators), so you can continue your work like you’re used to.