+ Reply to Thread
Results 1 to 3 of 3

Problems with quotation mark when exporting to a .txt file

  1. #1
    latet
    Guest

    Problems with quotation mark when exporting to a .txt file

    Hi,

    I have a hudge problem.
    The data I keep in Excel 2003 is very simple - just a big table
    filled with words (tekst). It's a kind of dictionary.

    I need to export it to a txt file. and I works great except
    one thing: when a cell contains a " mark it gets replicated,
    like:

    sam"ple ------> "sam""ple"

    The other thing happening - when a semicolon is used:

    dog; cat --------> "dog; cat"

    Is there a way to turn it off?
    (and please, don't tell me to use two apostrophes ' ' instead :-)

    Greetings,

    latet

  2. #2
    Diva
    Guest

    Re: Problems with quotation mark when exporting to a .txt file

    Make a copy of your excel file. Open the copy, save it using 'Save as'
    space delimited and not text delimited.


  3. #3
    latet
    Guest

    Re: Problems with quotation mark when exporting to a .txt file

    > Make a copy of your excel file. Open the copy, save it using 'Save as'
    > space delimited and not text delimited.


    Thanks, it solves the " problem indeed, but sadly, all the Unicode
    characters (Hebrew letters in my case) are questions marks now :-(
    Plus the spaces (many spaces) as delimiters won't make it easy for PHP
    to import and convert it into a database. I need 1-char delimiters.

    Thanks,

    latet



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1