Page 1 of 1

A Quattro Pro CVS file save as solution???

Posted: Sat Mar 15, 2008 8:48 pm
by FM WarB
The Quatro Pro spreadsheet program saves cvs files as comma delimited, as follows:
0,ENG,Highlanders,uni_ENG_Inf1,NULL,$uni_txt_ENG_Highlanders,$Land,Army_Highlander1_ENG.png.......etc, etc. No quotation marks. The settings cannot be changed.

I can open this file in Notepad and use find and replace to replace all commas " , " with semicolons " : "

Should this make the file useable for the cvs splitter?

Posted: Sat Mar 15, 2008 9:49 pm
by Primasprit
I would recommend that you download the excellent and free office suite Open Office: http://www.openoffice.org/
The spreadsheet program included in this package has configurable output filter for the csv-format.

Cheers
Norbert

Posted: Sat Mar 15, 2008 11:34 pm
by FM WarB
I'm trying to save space on HD for after I double RAM to add BoA 2, ACW, NCP, etc...

Posted: Sat Mar 15, 2008 11:44 pm
by lodilefty
FM WarB wrote:The Quatro Pro spreadsheet program saves cvs files as comma delimited, as follows:
0,ENG,Highlanders,uni_ENG_Inf1,NULL,$uni_txt_ENG_Highlanders,$Land,Army_Highlander1_ENG.png.......etc, etc. No quotation marks. The settings cannot be changed.

I can open this file in Notepad and use find and replace to replace all commas " , " with semicolons " : "

Should this make the file useable for the cvs splitter?


It might. Try doing it [save csv, global replace, csv splitter] for a file that you haven't modded, and compare to the original file from the 'vanilla'....

I use FCOMPARE for stuff like this - free, somewhere on the web... :o

but a semicolon is [SIZE="4"];[/size]
not [SIZE="4"]: [/size] :siffle:

Posted: Sun Mar 16, 2008 2:05 am
by FM WarB
Now you know why;;; I'd like a fully featured scenario editor: (colon)...Less typing! :)