Posted by Stephen Preston on 03/12/06 00:00
I have an xls worksheet I wish to export as a text or csv file to import
with fgetcsv()
The 'save as' function on excell lets me save as a comma separated value or
tab delimited text files.
Trouble is, some of my cells already have commas in them, so a tab or
something else would be better.
In the delimiter option of fgcsv(), can you specify a tab and how?
My other option (but a bit of a chore) is to copy and paste the xls data
into word, then replace all the tabs with something like ; that dosn't
appear in the cells.
thanks
[Back to original message]
|