SoftMaker.com

Wow Miguel, That is the exact answer I was looking for...talk about surgical...perfect. I can open all the .csv files that were giving me fits previously Woohoo! John PS - in my defense, I looked for a solution like this, but ran out of energy trying them. Now, how do I post an apple for you on this...

Oh, by the way...thanks for your help Martin.

This interaction was invaluable!

It matters when you rely on the csv files to be used by a vendor. It matters when errors get introduced into your product because a process cannot be strictly controlled. It matters when you Need byte for byte control on the csv file. Open the file Test File4.xlsx in PlanMaker Look at B1 ("Tues...

OK

So, don't use PlanMaker or any other spreadsheet program to edit csv files.

Is that the conclusion?

Regards,
John

Is there a way to open a csv file in PlanMaker, then save it without making any changes to it?
This is a basic tenant of all editors...if you open a file, make no changes, then save it, it compares exactly with the original file.

Is there a way to do this?

Regards,
John

OK Martin, I'm trying to understand. Just going through this process makes changes to my CSV file, even though this was not my intent. (I verified this using Notepad++ editor; it inserts double quotes; going through process over and over inserts another set of double quotes) Why does PlanMaker insis...

Conclusion: What I'm doing does not make sense because PlanMaker was never intended to be a .csv editor. While there may be editors out there that allow you to open, edit and close CSV files without an import and export process, PlanMaker is not one of them. Bottom Line: Use PlanMaker to edit Spread...

OK. So, the first part of what you said is add formatting. How do I do this? So, first I open the file that was saved as a .csv file. When it first opens, the Text import window pops up and it shows me the following: Character set Code page 1252 (Windows: Western Europe) selected Number of header li...

I see that Ctrl-S does a 'Save As.
But what does it mean to 'add them'?

Why does PlanMaker insist on converting a .csv file to a .pmdx file when it opens?
Is there any way to prevent this from happening?

Regards,
John

How do you open, edit and save as as csv file. When I open a .csv file it pops up a 'Text import' window. If I just click on OK without changing anything in this window, the file is imported OK and I can make changes. However, the file type gets changed to .pmdx Is there a way to open a file as a .c...