Excel And Notepad
 

Hello,

Have an Excel Spreadsheet that I saved in CSV format.

The program that imports and uses it, manages to import most of it
correctly, but messes up on some of the cells.

If I look at it in Notepad, or Notepad++ it looks 100% fine.

So, I thought I would like to try importing into the program
directly from Notepad or Notepad++

From what I can see in their Save As options, neither seems to allow
Saving as a CSV. A bit surprised, as I thought a CSV is pretty much a
text file, so CSV Saving should be easy from Notepad, or
Notepad++ which certainly has a lot of other Save options, though.

Does anyone know if it is possible to save a Notepad or Notepad++ file
as a CSV ? How ?

Thanks,
Bob

Excel And Notepad
 

"Bob" wrote:
Have an Excel Spreadsheet that I saved in CSV format.
The program that imports and uses it, manages to import most
of it correctly, but messes up on some of the cells.
If I look at it in Notepad, or Notepad++ it looks 100% fine.
So, I thought I would like to try importing into the program
directly from Notepad or Notepad++ [...].
From what I can see in their Save As options, neither seems
to allow Saving as a CSV.
[....]
Does anyone know if it is possible to save a Notepad or
Notepad++ file as a CSV ? How ?

In the Notepad Save As dialog box, select All Files in the "Save as type"
drop-down list. Then enter the file name, complete with the file extension
".csv".

But that might not solve your problem. Or it might not be necessary.

What language or application is "the program that imports and uses" the CSV
file?

How would you "try importing into the program directly from Notepad"?

What syntax in the CSV file save from Excel causes problems for the "the
program that imports" it?

If the "the program that imports" the file is another Excel workbook, and if
you intend to use VBA to invoke Notepad to "import into the program
directly" somehow, you could simply write your own macro to parse the CSV
file directly using the Line Input# statement.

Excel And Notepad
 

On Sat, 16 Nov 2013 09:19:55 -0500, Bob wrote:

Hello,

Have an Excel Spreadsheet that I saved in CSV format.

The program that imports and uses it, manages to import most of it
correctly, but messes up on some of the cells.

If I look at it in Notepad, or Notepad++ it looks 100% fine.

So, I thought I would like to try importing into the program
directly from Notepad or Notepad++

From what I can see in their Save As options, neither seems to allow
Saving as a CSV. A bit surprised, as I thought a CSV is pretty much a
text file, so CSV Saving should be easy from Notepad, or
Notepad++ which certainly has a lot of other Save options, though.

Does anyone know if it is possible to save a Notepad or Notepad++ file
as a CSV ? How ?

If it displays as a CSV file in Notepad, then that's what it will save as.


--
Steve Hayes from Tshwane, South Africa
Web: http://www.khanya.org.za/stevesig.htm
Blog: http://khanya.wordpress.com
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

From OP: Excel And Notepad
 

Hello,

Thank you all for the help. Very appreciated

All set now.

Bob
-------------------

On 11/16/2013 9:19 AM, Bob wrote:
Hello,

Have an Excel Spreadsheet that I saved in CSV format.

The program that imports and uses it, manages to import most of it
correctly, but messes up on some of the cells.

If I look at it in Notepad, or Notepad++ it looks 100% fine.

So, I thought I would like to try importing into the program
directly from Notepad or Notepad++

From what I can see in their Save As options, neither seems to allow
Saving as a CSV. A bit surprised, as I thought a CSV is pretty much a
text file, so CSV Saving should be easy from Notepad, or
Notepad++ which certainly has a lot of other Save options, though.

Does anyone know if it is possible to save a Notepad or Notepad++ file
as a CSV ? How ?

Thanks,
Bob