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: 444
Viewed: 2882
Added: Aug 19, 2002
Snippet uploaded by: snippet
Written By: Clint LaFever
Demo: Sorry, no demo

User Rated at: 1 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

Removes Single Quotes from a given string

Highlight all by clicking in box

Highlight All
' Author: Clint LaFever []
' Purpose: Used to remove Single Quotes from a string
' Parameters: pstr=String with single quotes.
' Returns: String without single quotes ' Example: mstr=RemoveSquotesmstr
Public Function RemoveSQuotes(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, "'")
RemoveSQuotes = 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 - 2017 All Rights Reserved. Conditions