![]() |
SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997 |
|
![]() |
#1 |
GLOBAL MODDING TERRORIST
|
![]()
One could convert the .off to a text file also.
The characters are Ascii or Extended Ascii so wouldn't be that hard. I'd think Excel would be able to handle extended Ascii. ![]() ä In the .off files translates to 228 which Exel should recognize. So appears they used Unicode - Latin Supplement A Can you send me a txt file that excel does not work with? Looking at the txt files in Notepad shows they are a mess. 010 opens them really good! So the import to Open Office always gives me fits! Last edited by Jeff-Groves; 07-24-23 at 02:11 PM. |
![]() |
![]() |
![]() |
#2 | |
Bosun
![]() Join Date: Sep 2021
Posts: 69
Downloads: 112
Uploads: 2
|
![]() Quote:
they're stock files like Agency_28.txt ,Chalk.txt, I use microsoft excel and libre office, can't find a suitable code match the 16bit display anyway Last edited by Bartholomew Roberts; 07-24-23 at 02:30 PM. |
|
![]() |
![]() |
![]() |
#3 |
GLOBAL MODDING TERRORIST
|
![]()
In Open Office? I import with Tabs as the seperator
Then select Western Europe (Windows-1252/WinLatin 1) Looks just like the txt file. Having figured all that out? I can write a script to convert the .off to a text file. Last edited by Jeff-Groves; 07-24-23 at 03:04 PM. |
![]() |
![]() |
![]() |
#4 | |
Bosun
![]() Join Date: Sep 2021
Posts: 69
Downloads: 112
Uploads: 2
|
![]() Quote:
Agency_28 dds ![]() Chalk ![]() the libre office can't read chalk txt correctly alone with excel ![]() for microsoft excel opens in 1252, another ghost story ![]() So it still has some trouble. Last edited by Bartholomew Roberts; 07-24-23 at 08:54 PM. |
|
![]() |
![]() |
![]() |
#5 |
Bosun
![]() Join Date: Sep 2021
Posts: 69
Downloads: 112
Uploads: 2
|
![]() ![]() Open office looks the same as libre office , " 226 113 10 32 the first letter caused the trouble, it only shows correctly in Notepad++ |
![]() |
![]() |
![]() |
#6 |
GLOBAL MODDING TERRORIST
|
![]()
In Open Office...............
There is a Text delimiter on import. DELETE the " or ' you find there. Leave it BLANK!!! The file will show correct then. For the most part anyway. There's still a few symbols that do not appear properly in a Spread sheet. ![]() I'm not a Spread Sheet expert nor use them myself. Seeing as one does not need to change those symbols but only the sizes? I'd code to adjust the sizes and leave the symbols alone. Last edited by Jeff-Groves; 07-25-23 at 10:27 AM. |
![]() |
![]() |
![]() |
#7 | |
Bosun
![]() Join Date: Sep 2021
Posts: 69
Downloads: 112
Uploads: 2
|
![]() Quote:
![]() |
|
![]() |
![]() |
![]() |
|
|