Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Colorado, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replacing a double quote (VBA/Access 2K)

    I have strings that are enclosed in double quotes. I need to strip the double quotes from these strings. How do I find occurences of the double quote in the string for replacement?

    Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Replacing a double quote (VBA/Access 2K)

    Hi Bill,
    I think the basic syntax you want is:
    Replace(strTextHere, """", "")
    I wasn't sure whether you meant that you had strings enclosed in double quotes with further double quotes within them and you only wanted to replace the internal quotes, or you just wanted to replace all double quotes, but either way you'll want the above at some stage.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,853
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Replacing a double quote (VBA/Access 2K)

    You could also search and destroy the Chr(34) character
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

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