Extract a substring

[vietnam97]

Hi,

is there a function in VB to extract a sub string out of a string? For example, I want to extract "Hello" out of "Hello World" string.

Thanks,
Bao

 

[cc4mail]

This should give you some ideas,

Private Sub Form_Load()

varTargetString = "Hello World"
varLookFor = "Hello"
varResult = Mid$(varTargetString, InStr(varTargetString, varLookFor), Len(varLookFor))
MsgBox varResult

End Sub

 

[JohnYingling]

Extract or Replace?

Dim lngInstr as Long
Dim strFind as string
strFind = "hello" ' test

lngInstr = Instr(1,strHe,strFind,vbTextCompare)
if lngInstr > 0 then
strResult = Mid$(strHe,lngInstr, Len(strFind))
End if

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[JohnYingling]

Warning. This statements throws an excepting if string not found because Instr will return 0 as a strting position and that is an invalid argument.

varResult = Mid$(varTargetString, InStr(varTargetString, varLookFor), Len(varLookFor))

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[cc4mail]

Good point John, that's why I'm a tech user, not a programmer.


Maybe you could help out with my thread? thread 222-189294

craig

craig@perfectform.com

 

[vietnam97]

Thanks John and Craig for helping out.

Bao