Not a Member Yet,
Click here to Register
How do you like the new design?
It's cool, great job
[tally: 70%] 70%
It's okay
[tally: 20%] 20%
Its OK but I liked the old layout better
[tally: 0%] 0%
Please bring the old one back
[tally: 10%] 10%

votes: 10

ID: 446
Viewed: 3004
Added: Aug 19, 2002
Snippet uploaded by: snippet
Written By: Clint LaFever
Demo: Sorry, no demo

User Rated at: 0 Stars
Rate This:

Thank you for your vote. Please wait...

It appears you already voted for this snippet

It appears your vote value was empty

Replaces all single quotes with ` instead.

Highlight all by clicking in box

Highlight All
' Author: Clint LaFever []
' Purpose: Used to replace Single Quotes in a string to ` instead.
' Parameters: pstr=String with single quotes.
' Returns: String without single quotes
Public Function ReplaceSQuotes(pstr As String) As String
On Error Resume Next
Dim spos As Integer
spos = InStr(pstr, "'")
While spos <> 0
pstr = Left(pstr, spos - 1) & "`" & Right(pstr, Len(pstr) - spos)
spos = InStr(pstr, "'")
ReplaceSQuotes = pstr
End Function ;

No Comments to show

Please completely fill out the form below if you want to review this snippet. All reviews are subject to validation.

Replying to a Comment...

Adding your comment. Please wait...

Thanks for adding your comment!. After further review it will be added.

There was a problem adding your comment. Please try again.

Please complete all the fields in the form before sending.

© 2002 - 2018 All Rights Reserved. Conditions