Problems with quotation mark when exporting to a .txt file

  • Thread starter Thread starter latet
  • Start date Start date
L

latet

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
 
Make a copy of your excel file. Open the copy, save it using 'Save as'
space delimited and not text delimited.
 
Make a copy of your excel file. Open the copy, save it using 'Save as'
space delimited and not text delimited.
Click to expand...

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
 
Back
Top