Part of a string

[ksilenio]

Hi to every one . I'd like to ask how can get a part of a string .Example: I have a string "StrA/Strb", now how can i get the part before the slash, or after the slash "StrB". Thank you for your time Regards

[Leith Ross]

Hello Ksilenio,

In VBA you would the Split function. This will return an zero based array (1-D) of the strings. You can specify the delimiter. The default is a comma.



Sub SplitStrings()

Dim n As Long
Dim Text As string
Dim vArray As Variant

Text = "StrA/StrB"
vArray = Split(Text, "/")

Text = ""

For n = 0 To UBound(vArray) - 1
Text = Text & vArray(n) & vbLf
Next n

MsgBox Text

End Sub

[Paul_Hossler]

VBA way



Option Explicit


Sub test()
Dim v As Variant
Dim s As String

s = "StrA/StrB"

v = Split(s, "/")

MsgBox v(0) ' starts at 0
MsgBox v(1)

End Sub

[ksilenio]

Thank you Leith ,but, can you explain me
1. what does it mean "vbLf" and
2. how to get the string after the slash
Regards

[Leith Ross]

The vbLf is a string constant for the Line Feed character Chr(10). See Paul's post for breaking down individual strings.

[ksilenio]

Hi Paul , thank you for your answer but how get the string after the slash ,mean "StrB"

Ok I found it Paul .Thank you Paul