Left of a character in a string in vb.net

Question

Hello,

say if I have a string 010451-09F2

How to I get left of - from the above string in vb.net

I want 010451

The left function doesn't allow me to specify seperator character.

Thanks

Answer 1

Get the location of the dash first (or do it inline), and use that value for the left. This is old school VBA, but it'll be something like this:

Left(YourStringWithTheDash, InStr(YourStringWithTheDash)-1)

Answer 2

Dim str As String = "010451-09F2"
Dim leftPart As String = str.Split("-"c)(0)

Split gives you the left and right parts in a string array. Accessing the first element (index 0) gives you the left part.

Answer 3

Sorry not sure on the vb syntax, but the c# is

 string mystring ="010451-09F2";
 string whatIwant = mystring.Split('-')[0];

Answer 4

dim s as String = "010451-09F2"
Console.WriteLine(s.Substring(0, s.IndexOf("-")))
Console.WriteLine(s.Split("-")(0))

Answer 5

Given:

Dim strOrig = "010451-09F2"

You can do any of the following:

Dim leftString = strOrig.Substring(0, strOrig.IndexOf("-"))

Or:

Dim leftString = strOrig.Split("-"c)(0) ' Take the first index in the array

Or:

Dim leftString = Left(strOrig, InStr(strOrig, "-"))
' Could also be: Mid(strOrig, 0, InStr(strOrig, "-"))

Answer 6

Use something like this:

Mid("010451-09F2",1,InStr("-"))

Answer 7

    Dim sValue As String = "010451-09F2"
    Debug.WriteLine(sValue.Substring(0, sValue.IndexOf("-"c)))