Guru80 wrote:Leave Character Set alone, Change Field Delimiter to semi-colon ( ; ), delete the Text Delimiter so it is blank, leave the check boxes alone, click OK and it will save as the CVS file.
squarian wrote:Newb first attempt here - I've d/ld OpenOffice.org 3.3.0, which appears to be latest version on OpenOffice website.
Open xls file, make change, click "save as".
Select "text csv" (which is the only csv option listed in dropdown menu)
Select "edit filter settings"
Dialogue box appears ("Export of text files") with a preset character set (Western Europe Windows-1252/WinLatin1) and dropdown menus for field delimiter and text delimiter.
I set field delimiter to semicolon ( .
[color="red"]I pull down text delimiter looking for "none/blank" - [B]and here's the glitch - the only options on this list are single quote mark (') or double quote mark ("). [/color][/B]
Per AgeWiki instructions, none/blank is necessary - but where is it? Help?
When exporting the csv files, you must define the “Field Delimiter" as a semicolon [B]; and the 'text delimiter' as [/B]
[B]none or blank. [these are the English language terms from Open Office©] [/B]
This is absolutely required for ALL files from the spreadsheet DB being prepared for use
[Models, Units, weathers, abilities, etc.], not just scenarios.
Franciscus wrote:Hello guys.
Regarding CSV files, are you using Openoffice or LibreOffice ?
I tried Excel, but could not find a way to configure adequately the CSV exporting options...
Users browsing this forum: No registered users and 21 guests