On Mon, February 18, 2008 7:11 am, Graham Cossey wrote:
> I was wondering if someone could offer some advice please.
>
> I'm being sent data in tab delimited files which I'm trying to split
> into smaller files and convert to comma delimited using PHP.
>
> Now, I can replace the tabs with commas and opening the resulting
> files in a basic text editor all looks fine. However when I open the
> files in M$ Excel they're still being treated as tab delimited and all
> values are being shoved into a single column.
>
> What can I do in the PHP code to specifically make the file CSV and be
> treated as such by M$ Excel?
>
> I'm currently just using fopen for old and new files and fwrite.
First, note that MS Excel is quite happy to import tab-delimited if
you punch the right radio buttons on the import dialog...
Next, use fgetcsv and fputcsv with different args ("\t" and ",") to
read/write the files, and you should get valid CSV files.
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/from/lynch
Yeah, I get a buck. So?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
