Re: Screwed Up File Names and Hyperlinks

I checked my home PC, from which, I think, the issue that I reported
originated. Its Regional and Language settings set to English (US) and
codepage conversion tables 1250-1258 checked (and grayed-out), as well as
several others. The ones that are grayed-out can't even be unchecked.

I still do not understand, even if the codepages were "confused," why only
some of the '-' characters were converted in the file (document) name on
disk. I know that, when the Excel rows were hyperlinked to the document,
the correct name existed on disk because that's how I discovered the
problem; i.e., I selected one of the Excel entries to read the document and
it said it couldn't open the specified file. So obviously (to me, anyway)
the character got changed later.

Jerry C. Adams
IBM i Programmer/Analyst
"Derrick" - (originally a scaffold) named after London hangman Goodman
Derrick. -EUI
--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of John Jones
Sent: Friday, May 04, 2012 2:16 PM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] Screwed Up File Names and Hyperlinks

Most of the other characters, like regular alphanumerics, are the same on
the different code pages. So while you might think you're viewing a Latin
US code page display, Windows might be using Windows Latin 2. Normally the
browser detects & encodes correctly, but sometimes the pages aren't encoded
properly or the server/browser defaults are used but the page uses something
else. In Firefox you can click the orange Firefox drop-down, select Web
developer then Character encoding to view/change the encoding.
Play with that on a text-heavy page and you'll see what I mean.

Cut-n-paste has gotten smarter as well so when you pasted the addresses in
some encoding & formatting came along for the ride. It still looked fine
but I'm going to guess that Excel saved everything under a single encoding
and that changed the ' and - to what you're seeing.



On Fri, May 4, 2012 at 1:21 PM, Jerry C. Adams <midrange@xxxxxxxx> wrote:

I see, but why would it just be those two characters and only

occasionally?

I read the chapters preceding the appendices, but couldn't find
anything about how to set the codepage on the PC - just how to develop
international-capable software. So I checked my settings on this PC
under the Control Panel's "Regional and Language Options" and it said
it was English(US). I did notice that there were a lot of codepage
conversion tables checked and, in some cases, even grayed-out,
including codepage 1250 (couldn't find one for 437).

Jerry C. Adams
IBM i Programmer/Analyst
"Bloomers" - named for 19th century social reformer Amelia Jenks Bloomer.
-EUI
--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]
On Behalf Of John Jones
Sent: Friday, May 04, 2012 11:41 AM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] Screwed Up File Names and Hyperlinks

Your code pages are out of sync. See characters 146 & 150 on the
below two pages.

Code Page 1250 Windows Latin 2 (Central Europe)
http://msdn.microsoft.com/en-us/library/cc195052.aspx
Code Page 437 MS-DOS Latin US
http://msdn.microsoft.com/en-us/library/cc195060.aspx


On Fri, May 4, 2012 at 10:59 AM, Jerry C. Adams <midrange@xxxxxxxx> wrote:

Maybe, but the Character Map utility in Windows says Æ is "Latin
capital letter Ae" (whatever that is) and Û is "Latin capital Letter
U with circumflex".

Office apps, I agree, seem to have a mind of their own; perhaps they
are smarter than me. Thing is I've been doing this for years and it
just

reared

its ugly head recently. I'll down check my home PC this weekend
after I dump my corrected thumbnail folder to it.

Jerry C. Adams
IBM i Programmer/Analyst
The first winner, 1978, of the Diagram Prize (for the book with the
oddest
title) was "Proceedings of the Second International Workshop on Nude

Mice".

--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx
[mailto:pctech-bounces@xxxxxxxxxxxx]
On Behalf Of David Gibbs
Sent: Friday, May 04, 2012 10:45 AM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] Screwed Up File Names and Hyperlinks

On 5/4/2012 10:36 AM, Jerry C. Adams wrote:

I have been experiencing something just really weird. I keep
track of articles, tips, etc., for future reference by copying
them to a Word document and logging them to an Excel spreadsheet.

This is something I avoid ... mainly because MS Office applications
have a nasty habit of thinking they know what you want more than you do.

I noticed the other day that certain characters in *some* of the
documents had been changed. Specifically the apostrophe (') was
changed to Æ and dashes (-) were changed to û. (The dash, by the
way, only got changed if there was a space before it, not as far
as I have been able to find, in a hyphenated word.)

The dash might have been converted into an 'en-dash' (double dash).

The apostrophe might have been converted into properly apposing

apostrophes

(` and ')

david



--
IBM i on Power - For when you can't afford to be out of business

I'm riding on the American Diabetes Association Tour de Cure to
raise

money

for diabetes research! To sponsor me, visit http://urlq.us/adaride
--
This is the PC Technical Discussion for iSeries Users (PcTech)
mailing

list

To post a message email: PcTech@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/pctech.

--
This is the PC Technical Discussion for iSeries Users (PcTech)
mailing

list

To post a message email: PcTech@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/pctech.

--
John Jones, CISSP
--
This is the PC Technical Discussion for iSeries Users (PcTech) mailing

list

To post a message email: PcTech@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/pctech.

--
This is the PC Technical Discussion for iSeries Users (PcTech) mailing

list

To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.