How do I import a number from a text file with a coma on it ?

  • Thread starter Nikos Yannacopoulos
  • Start date
N

Nikos Yannacopoulos

Martin,

Please be more specific! What does the text file look like, and what do
you want to do?

Nikos
 
M

Martin

How can I custom import ? I have a column with some numbers and some others
that I want to import also as number but in the txt file are in this format:
"1,256" Can I take out " ?

Thank you very much, Martín.
 
N

Nikos Yannacopoulos

Start the process to link the text file; use the options in the wizard
to declare the double quotes as text qualifier. This will result in the
string being read without the quotes in the linked file.

Nikos
 
Top