Results 1 to 2 of 2

Thread: How to replace " (double quotes) with '

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2000
    Posts
    2

    Angry How to replace " (double quotes) with '

    I am trying to read a text file and wish to replace all occurences of double quotes with a single quote.

    I have tried :
    Replace(textstring , " \" " , " ' ")
    Replace(textstring , ' " ' , " ' ")

    But get an error.




  2. #2
    Fanatic Member
    Join Date
    Mar 2000
    Location
    That posh bit of England known as Buckinghamshire
    Posts
    658

    Thumbs up Give this a whirl

    Code:
    'use the characters code
    myStr = Replace(myStr, Chr(34), "'")
    
    'or this works.
    myStr = Replace(myStr, """", "'")
    Iain, thats with an i by the way!

Posting Permissions

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



Click Here to Expand Forum to Full Width