Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Filter for ** (Excel 2002)

    Hi,
    I can filter for all records beginning with an * by using Begins with ~* as an AutoFilter. How can I only filter for the records beginning with two asterixes, ie. ** ?

    Any ideas?
    Tx
    Regards,
    Rudi

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

    Re: Filter for ** (Excel 2002)

    How about Begins with ~*~*
    This will filter all records where the column begins with 2 asterisks
    Or do you mean EXACTLY two asterisks, and no more?

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filter for ** (Excel 2002)

    Not working Hans?
    Here is a cut down version of the file.

    Begins with ~*~* still filters all records with a *!

    Cheers
    Regards,
    Rudi

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filter for ** (Excel 2002)

    Rudi

    How about this?
    Jerry

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filter for ** (Excel 2002)

    Thanx Jerry. It works well!

    However...as i was meddling with it, I managed to "by chance" stumble upon another solution. I notice that ~*~* * also works????
    That is ~*~*(space)*. I am assuming the last asterix represents the string after the two asterixes??? Do I assume correctly?

    Thanx for the replies!!
    Regards,
    Rudi

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

    Re: Filter for ** (Excel 2002)

    An asterisk * without a tilde ~ before it stands for the wildcard "any number of characters". The ~ is used to specify that * is to be interpreted literally, as the character * itself.

    In your table, 2 asterisks are either followed by a space or by more asterisks, so <code>~*~* *</code> will work. If you had entries such as
    <code>**12345 Widgets</code>
    (i.e. without a space after the asterisks) that wouldn't work.

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filter for ** (Excel 2002)

    Good question Rudi.

    I think you presumption is correct. It is looking for "** [space]" and then any character or string.

    So Yes, logically it is looking for ** at the beginning but as long as you have a space between the ** and the rest of the string.
    Jerry

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filter for ** (Excel 2002)

    Thanx Mr H and Mr J.
    That is pretty clear now!
    <img src=/S/hello.gif border=0 alt=hello width=25 height=29>
    Regards,
    Rudi

Posting Permissions

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