Not a Member Yet,
Click here to Register

ID: 446
Viewed: 3598
Added: Aug 19, 2002
Version:
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
<!---Declaration--->
none

Highlight All
<!---Code--->
'------------------------------------------------------------ 
' Author: Clint LaFever [lafeverc@home.com]
' 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, "'")
Wend
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 - 2024 snippetlibrary.com All Rights Reserved. Conditions
Do NOT follow this link or you will be banned from the site!