Visual Basic Loop Through Array of Strings

Question

I am trying to extract a sub string from a string using Visual Basic.

This is what I have tried:

Dim TestString = "Aberdeen, 1"
for i = 0 to TestString.length-1
debug.print(teststring(i))
next

What I would like to do is loop through the TestString so that it only extracts and prints the words "Aberdeen" WITHOUT the comma and the number 1. So far, all the characters are getting added.

Any help much appreciated.

Could TestString have other values? Should it simply stop when it finds a comma? — Andrew Morton
– Andrew Morton, Commented Jan 30, 2020 at 9:24
yes it needs to stop the loop at the comma and spit the word Aberdeen out. — Hexana
– Hexana, Commented Jan 30, 2020 at 9:25

Andrew Morton · Accepted Answer · 2020-01-30 09:33:46Z

2

Assuming you are using VB.NET, you can create a LINQ statement which will take characters from the string until (but not including) it finds a comma:

Dim TestString = "Aberdeen, 1"
Dim toComma = TestString.TakeWhile(Function(c) c <> ","c)
For Each c In toComma
    Debug.WriteLine(c)
Next

If you know that there is a comma, it could be:

Dim toComma = TestString.Split({","c}, 2)(0)

Or:

Dim toComma = TestString.Substring(0, TestString.IndexOf(","c))

answered Jan 30, 2020 at 9:33

Andrew Morton

25.3k9 gold badges66 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hexana Over a year ago

This is awesome. Thank you very much. I'm new to VB and have been trying to work this one out. Thanks for your help.

Collectives™ on Stack Overflow

Visual Basic Loop Through Array of Strings

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related