Replacing text
If you want to replace all occurances of a string, you can use the Replace
function (only available in VB6.. you'll have to create your own if you have
VB5 or lower).
Replace(StringToSearch, StringToFind,
ReplaceString, Start, Count, Compare)
The first 3 parameters speak for themselves.... The Start, Count and Compare
paramters are all optional. Start specifies where to start replacing from, count
specifies the maximum number of replaces, and compare specifies if it is case
sensitive (vbBinaryCompare), or not (vbTextCompare).
The following code replaces all occurances of "Jane" with "Bob"
in the Text1 textbox
Replace(Text1.Text, "Jane", "Bob")
-
Posted by KöllMorgan on 14 Jan 2007
Here we go again:
After hours of debugging, I found out the only instance the first word on the second line does not get picked up is when I physically tab or hit enter and enter or type ad...
-
Posted by KöllMorgan on 14 Jan 2007
Replying to my own post...Hiya!
I found out the trick to grabbing the first word in the string using the above code:
InStr(1," " & YourString & " ", " " & YourSearc...
-
Posted by KöllMorgan on 13 Jan 2007
Hello!
Wonderful, helpful site, by the way...
I am working on a small program for a friend and noticed the below code. Works flawlessly, accept t...
Posted by koti_sastry on 06 Dec 2005
i know i am answering to an oldest question left unanswered..
but.. i just wanted to answer it..
just for some one who is searching on a specific topic ...and end up in finding only question...
-
Posted by fatwalrus on 17 Feb 2005
[b]I included a code extract here but you have to click on "read comments" to see it all.[/b]
[i]Basically it just searches the text string for 2 spaces in row, and replaces it with one space, the...