Re: Re: Convert HTML Table to Tab Delimited .TXT file
| From: | dpgirago at mdanderson dot org | Date: | Mon, 24 May 2004 14:41:37 +0000 |
| Subject: | Re: Re: Convert HTML Table to Tab Delimited .TXT file | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34537@lists.php.net to get a copy of this message | ||
Thanks for responding, Torsten. If I'm understanding your suggestion, then
what happens where the data from the dB already has a ; (semi-colon) in
it? Wouldn't this corrupt the import into excel?
dave
>> My question is whether there might be a more direct way to get the dB
data
>> into excel on the client PC (can't imagine how), or if not, how I might
>> create a 'tab delimited' file from the HTML table and avoid introducing
a
>> foreign character as a field separator.
> A comma seperated values file (.csv) should be readable by Excel. Just
put a
> ; between all values and save it as a text file with .csv extension. I
think
> you don't need to go all the way via HTML output and copy/paste.
> Regards, Torsten Roehr