Autor Thema: Export Comments CSV  (Gelesen 4326 mal)

Offline ndzied1

  • Jr. Member
  • **
  • Beiträge: 40
  • One if By Land
Export Comments CSV
« am: Mai 05, 2006, 07:46:05 Vormittag »
I am trying to export the comments to a CSV file and then read them into Excel but Excel doesn't like the file.  When I read it into a text editor, there seems to be a space (hex 20) character between each character I typed. 

Has anyone else seen this.  Perhaps is it caused by using or not using unicode text?

Thanks,

Norm Dziedzic

Offline KressSwiss

  • easy god
  • *****
  • Beiträge: 1659
  • Und sie dreht sich doch..."Galileo Galilei"
    • Electronics Planet
Re: Export Comments CSV
« Antwort #1 am: Mai 05, 2006, 12:21:49 Nachmittag »
Hi Easy-User
Had the same experience. Try it in the folowing way:
Open Excel
For import select:
Dateityp (*.prn *.txt *.cvs)
Open your *.cvs and follow the 3 steps of the assistent

Little bit complex isn't it? Have an result-example in the appendix
Wish you lot of sucess
KerssSwiss
« Letzte Änderung: Mai 05, 2006, 20:29:10 Nachmittag von KressSwiss »
Achtung:
Angehängte Dateien sind nur für eingelogte User sichtbar!

Offline ndzied1

  • Jr. Member
  • **
  • Beiträge: 40
  • One if By Land
Re: Export Comments CSV
« Antwort #2 am: Mai 05, 2006, 14:16:43 Nachmittag »
Thank you,

I had to additionally select that the file was in unicode (UTF-8) but it worked.

I am running Excel 2003.