Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    87

    Unanswered: Find & Replace Query - Query built, just need a minor edit for quote replacement.

    Hello,

    I'm trying to use a template that I learned from the help I found on dBforums.com but I realized that this doesn't work for quotes. I need to edit this so that I can replace " with -.

    The / that's in the code should be the only thing that I'm editing but its giving errors such as "extra expression"

    I'd like it to work for double quotes and single quotes ( example " and ' )

    Here's my template

    Code:
    UPDATE [ONE BIG TABLE] SET [ONE BIG TABLE].url_key = Replace(url_key,"/","-")
    WHERE ((([ONE BIG TABLE].url_key) Like "*/*"));
    Here's my edit (with a " instead of / )

    Code:
    UPDATE [ONE BIG TABLE] SET [ONE BIG TABLE].url_key = Replace(url_key,""","-")
    WHERE ((([ONE BIG TABLE].url_key) Like "*"*"));
    Last edited by RBusiness; 02-24-12 at 12:34. Reason: Added objective

  2. #2
    Join Date
    Aug 2010
    Posts
    87
    Update: I ended up doing it manually through the in table find and replace but I'd still like to know if anyone wants to chime in!

Posting Permissions

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