1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Help with wildcards for find and replace

Discussion in 'Business Applications' started by labecs, Mar 27, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. labecs

    labecs Thread Starter

    Joined:
    Dec 13, 2006
    Messages:
    137
    I need to erase all instances of lines like:

    BOB TO ROSE)

    ROSE TO BOB)

    PETER TO ROBERT)

    What's the wild card I have to use to have them all erased without erasing all the caps from the rest of the document which are in regular sentence case....

    Can you please help me? I can't figure it out!
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,965
    First Name:
    Wayne
    whats the application you are using
    word
    excel
    powerpoint
    access
    other
     
  3. labecs

    labecs Thread Starter

    Joined:
    Dec 13, 2006
    Messages:
    137
    ooops.... sorry: Word
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,965
    First Name:
    Wayne
    from word help - i searched for wildcards
     
  5. labecs

    labecs Thread Starter

    Joined:
    Dec 13, 2006
    Messages:
    137
    Thank you, but I know what the procedure is to use wildcards, but I am looking for a particular combination that I can use to replace:
    BOB TO ROSE)
    ROSE TO BOB)
    all instances of a series of capital letters with a parenthesis at the end. I can't find the rigt combination of signs to accomplih this without erasing all the capital letters in the document.
    Can you recommend a forum where I can ask this?

    Thank you in advance.
     
  6. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,965
    First Name:
    Wayne
    so *) does not work
     
  7. labecs

    labecs Thread Starter

    Joined:
    Dec 13, 2006
    Messages:
    137
  8. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    To search for Wildcards in Word click FIND and then click the button that says MORE to expand your search options. Check the box that says "Use Wildcards" and then enter *[)] as your search criteria.

    If that doesn't work please post a sample document? Depending on how the data appears in your document I may be able to write a VBA macro to do this.

    Regards,
    Rollin
     
  9. labecs

    labecs Thread Starter

    Joined:
    Dec 13, 2006
    Messages:
    137
    I got this wild card from a friend and it worked wonders:[ A-Z]@\)^013.

    Saved me tons of time!

    The document is a film script and it goes: ALEX TO DORIS)
    Doris, I love you!
    DORIS TO ALEX)
    Well, I don't.

    So I wanted to get rid of all the names. But the wildcard I got works great.
    Thank you!
     
  10. jdl

    jdl

    Joined:
    Jan 4, 2005
    Messages:
    621
    Thanks for posting the solution! I'm glad it worked for you, but I can't get it to work for me...
     
  11. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    I couldn't get it to work either - I tinkered a bit with it and it would take out the lines labecs wanted out, but it also removed all the capital "A"s at the beginning of sentences (and I suspect it would remove all the capital "Z"s).
     
  12. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/555417

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice