Not a Member Yet,
Click here to Register

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

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