INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
"...I'm so glad I found this site... Now I can get some sleep, because my problem is solved..."
Where in the world do Tek-Tips members come from?
How do I replace a character in a string?
Posted: 18 Jan 01
Use the built in Replace VB function to replace any occurrence of one string or set of characters in a string with any other string or set of characters.
The syntax for the Replace function is:
Replace(string being manipulated, unwanted characters, alternative characters)
where unwanted characters are the characters (may only be one character, eg " or ') that you want to remove from your string, and alternative characters are the characters (again may only be one character, like a space) to be used in place of the unwanted characters.
So, if you have a variable, sString say, that holds the string He said, "Hello". and you want to replace the double quotes with single quotes, then you would use the following line:
sString = Replace(sString, Chr(34), Chr(39))
transforming sString to He said, 'Hello'.
Here Chr(34) is a double quote and Chr(39) is a single quote.
Back to Visual Basic(Microsoft): Version 5 & 6 FAQ Index
Back to Visual Basic(Microsoft): Version 5 & 6 Forum
Join Tek-Tips® Today!
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
- Talk To Other Members
- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close