SUBSIM Radio Room Forums



SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997

Go Back   SUBSIM Radio Room Forums > Silent Hunter 3 - 4 - 5 > Silent Hunter 4: Wolves of the Pacific > SH4 ATO Mods
Forget password? Reset here

Reply
 
Thread Tools Display Modes
Old 07-24-23, 12:30 PM   #1
Jeff-Groves
Village Idiot
 
Jeff-Groves's Avatar
 
Join Date: Sep 2014
Posts: 5,397
Downloads: 131
Uploads: 0


Default

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.
Jeff-Groves is offline   Reply With Quote
Old 07-24-23, 02:15 PM   #2
Bartholomew Roberts
Bosun
 
Join Date: Sep 2021
Posts: 69
Downloads: 107
Uploads: 2
Default

Quote:
Originally Posted by Jeff-Groves View Post
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!
It's in the Silent Hunter 4 Wolves of the Pacific Gold Edition\Data\Menu\Fonts
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.
Bartholomew Roberts is offline   Reply With Quote
Old 07-24-23, 02:52 PM   #3
Jeff-Groves
Village Idiot
 
Jeff-Groves's Avatar
 
Join Date: Sep 2014
Posts: 5,397
Downloads: 131
Uploads: 0


Default

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.
Jeff-Groves is offline   Reply With Quote
Old 07-24-23, 08:37 PM   #4
Bartholomew Roberts
Bosun
 
Join Date: Sep 2021
Posts: 69
Downloads: 107
Uploads: 2
Default

Quote:
Originally Posted by Jeff-Groves View Post
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.
Yes, it shows correctly with (Windows-1252/WinLatin 1) but they are different letters from font to font. Take Agency_28 and chalk for example. With same format chalk can't be read correctly.

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.
Bartholomew Roberts is offline   Reply With Quote
Old 07-24-23, 09:29 PM   #5
Bartholomew Roberts
Bosun
 
Join Date: Sep 2021
Posts: 69
Downloads: 107
Uploads: 2
Default



Open office looks the same as libre office , " 226 113 10 32 the first letter caused the trouble, it only shows correctly in Notepad++
Bartholomew Roberts is offline   Reply With Quote
Old 07-25-23, 09:01 AM   #6
Jeff-Groves
Village Idiot
 
Jeff-Groves's Avatar
 
Join Date: Sep 2014
Posts: 5,397
Downloads: 131
Uploads: 0


Default

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.
Jeff-Groves is offline   Reply With Quote
Old 07-25-23, 10:41 AM   #7
Bartholomew Roberts
Bosun
 
Join Date: Sep 2021
Posts: 69
Downloads: 107
Uploads: 2
Default

Quote:
Originally Posted by Jeff-Groves View Post
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.
Oh, I didn't notice that , that also works for libre office. Years passed I almost forgot how to use spreadsheet. You need to do script both reading and writing off file, good luck.
Bartholomew Roberts is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 02:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 1995- 2024 Subsim®
"Subsim" is a registered trademark, all rights reserved.