Excel is stripping off quotation marks from .csv files if

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maryanne - 27 Jan 2006 22:07 GMT

Need to import .csv files into a application with quotes around the values in
a field.
Excel is stripping off quotation marks from .csv files if the field contains
a number.
Have a .csv file that is exported. Each field is comma separated and has
quotation marks around the value in the field. Example

"Jerry","Smith","10 10th Street","New City", 'New State" ,"97744"

If I open the file in Excel it removes the quotes from 10 10th Stree and
97744 and I cannot import them. Is there a setting or .vbs script I can run
to make sure all the fields have quotation marks?

Reply to this Message

Gary''s Student - 27 Jan 2006 23:50 GMT

Re-name the file to .txt

When you open the file, Excel will start the Import Wizard. Tell the Wizard
that the field as yrxt and it will leave the quotes alone.

Signature

Gary's Student

> Need to import .csv files into a application with quotes around the values in
> a field.
[quoted text clipped - 8 lines]
> 97744 and I cannot import them. Is there a setting or .vbs script I can run
> to make sure all the fields have quotation marks?

Reply to this Message

Maryanne - 28 Jan 2006 02:19 GMT

is htere a way to add quotation marks to .csv files opened excel after they
have been stripped out or if the files never had them, but we need to import
that data into our application?

Thanks

> Re-name the file to .txt
>
[quoted text clipped - 13 lines]
> > 97744 and I cannot import them. Is there a setting or .vbs script I can run
> > to make sure all the fields have quotation marks?

Reply to this Message

Maryanne - 28 Jan 2006 02:27 GMT

I am not very familiar with Excel but in the wizard I cannot find anywhere I
would tell Excel the format was yrxt, can you give me more details?

> is htere a way to add quotation marks to .csv files opened excel after they
> have been stripped out or if the files never had them, but we need to import
[quoted text clipped - 19 lines]
> > > 97744 and I cannot import them. Is there a setting or .vbs script I can run
> > > to make sure all the fields have quotation marks?

Reply to this Message

Pete_UK - 28 Jan 2006 02:37 GMT

I think that was a typo and should have been text. It's in the third
panel, once you have told excel where to start from and what the
delimiters are, it divides the file up (you can see the first few rows)
and you can highlight a column and click the text button (or date, or
skip - default is general).

Hope this helps.

Pete

Reply to this Message

Dave Peterson - 28 Jan 2006 02:39 GMT

You could use a macro:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Earl's program has a supports lots of different options. You may want to see if
that works for you right out of the box.

> is htere a way to add quotation marks to .csv files opened excel after they
> have been stripped out or if the files never had them, but we need to import
[quoted text clipped - 21 lines]
> > > 97744 and I cannot import them. Is there a setting or .vbs script I can run
> > > to make sure all the fields have quotation marks?

Signature

Dave Peterson

Reply to this Message