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

  • Thread starter Thread starter Guest
  • Start date Start date
Martin,

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

Nikos
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change decimal dots per coma (in word) 3
How do I import a delimited text file into Access? 1
Coma Separator in Numbers 1
Code to insert a coma 26
convert a pst file to a coma delimited 1
How can I tell a macro to go to . . . 4
Importing Text Files Into Access 1
How do I count just the numbers in a cell, no spaces or comas? 2

Back
Top