Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    {1,} wildcard fails in Swedish locale (Word 2003 SP2)

    "[0-9-]{1,}" wildcard pattern to match one or more digits and/or hyphens works perfectly in English Word but fails with "invalid wildcard expression" error in Swedish Word if the locale is set to Swedish. But it works if the user sets the locale to English (Control Panel->Regional settings).
    Also fails in standard English Word if I set locale to Swedish.
    It's the comma that causes the problem, because "[0-9-]{5}" works perfectly in both locales. Swedish uses comma for a decimal point -- so it probably fails in other locales that do the same.
    How do the Swedes ever do any wildcarding?
    Does anybody know a way I can report this bug to Microsoft?
    Word versions are: Swedish: 2003 (11.5604.6360)
    English: 2003 (11.6568.6568) SP2
    Both running on XP, mine is Professional, Service Pack 2

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: {1,} wildcard fails in Swedish locale (Word 2003 SP2)

    Try using a semicolon <code><big>;</big></code> instead of a comma <code><big>,</big></code>
    (When the comma is the decimal separator, a semicolon is generally used as list separator)

  3. #3
    New Lounger
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: {1,} wildcard fails in Swedish locale (Word 20

    Thanks, Hans, that was the answer.
    I found out that I can specify the separator in my macros in a way that works, no matter what the locale is set to:
    With Selection.Find
    ' .Text = "[0-9]{1,}"
    ' .Text = "[0-9]{1;}"
    .Text = "[0-9]{1" & Application.International(wdListSeparator) & "}"

    No doubt about it, Woody's is the place to come for answers!

    It seems very "slack" of Microsoft to not provide any information in VBA about the {m,n} pattern. The programmer has to look in Word help to find that. Even in the Swedish version of Word, with menu entries and style names in Swedish, the help still says to use {m,n}.

    Since the language of VBA is unashamedly English, perhaps they should have stuck with {m,n} in all locales. Then the program would match the help file.

    Do you know if there is any way of feeding these ideas back to Microsoft?

    Jim

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: {1,} wildcard fails in Swedish locale (Word 20

    You can send an e-mail to mswish@microsoft.com. State your request clearly and consisely, with a brief explanation why you think it would benefit users. Don't get your hopes up high...

  5. #5
    New Lounger
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: {1,} wildcard fails in Swedish locale (Word 20

    Thanks again, Hans, I'll try it.

    Jim

  6. #6
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: {1,} wildcard fails in Swedish locale (Word 20

    Don't get your hopes up high, indeed. I've sent dozens, maybe hundreds of mails to mswish over the years and have never, ever had a followup question asked.
    For a while you used to get an automated receipt mail, but that has stopped too.

    Some people (even from MS) say that mswish is completely dead, and that you should post your suggestions and feedback on the web interface to the MS newsgroups.
    I've hardly seen any reaction by MS on these suggestions either, though I'd still prefer that since at least it's public, and it is a good feeling to know *somebody* will read it (even if not somebody at MS).

    Added since I'm comfortably in rant mode: I've posted suggestions to a web interface for suggestions and feedback for more than two years (http://support.microsoft.com/support/feedback ... sure official-looking!).
    Often I took days, hours or even weeks to track down bugs and post them there, and sent the link to others.

    Later I found out that this web interface had been a project by somebody at MS who switched positions and forgot to take the web site down. Nobody at MS knew about it, and from the very start all my posts had gone straight to the null device.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Klaus

  7. #7
    New Lounger
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: {1,} wildcard fails in Swedish locale (Word 20

    Thanks for joining in, Klaus.

    I just received the following reply, which seems to be from a human!:
    <<<
    Hello Jim,

    Thank you for contacting Microsoft Online Customer Service.

    I appreciate the time taken on your part to write to us regarding your issue

    I have forwarded your feedback to the Development Team, for further review on this issue. If you have further issues or concerns, please write to us for assistance, we would be glad to assist you.

    Thank for using Microsoft products and services.

    Clive
    Microsoft Online Customer Service Representative

    If you have any feedback about your Online Customer Service experience, please email my manager, Sujith Sadasivan, at managers@microsoft.com

    >>>

    Klaus, I found your item (with Graham Mayor) about wildcards helpful (on word@mvps.org), and I sent a response to them, in which I suggested you add something like the following to the article:
    <<<<
    The Word help files show a comma as the separator in {m,n}, and that is true
    if your locale is English, but it is actually the "List separator" that is
    specified in the locale. The user can see what this is and change it (in Win
    XP) by opening Control Panel-->Regional and Language Options, and then
    operating the Customize button. This item is near the bottom of the dialog.

    A VBA programmer can write a macro that will work in any locale by replacing
    an expression like

    "{2,6}"

    with

    "{2" & Application.International(wdListSeparator) & "6}"

    >>>>

    Bye for now,
    Jim

  8. #8
    5 Star Lounger
    Join Date
    May 2001
    Location
    Stuttgart, Baden-W, Germany
    Posts
    931
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: {1,} wildcard fails in Swedish locale (Word 20

    A reply on a mail to MSWish?? Wow! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> I hadn't thought it possible.

    Thank you for your suggestion re the wildcard article. Shame on us that we missed that <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    I haven't access to change the article, but if I get a chance to update it, I'll stick something like your text in.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Klaus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •