Example. We first import System.Text.RegularExpressions. This program matches all the quoted values within the example value string.
Step 1 We call Regex.Matches with a pattern that means we want zero or more characters inside single quotes.
Step 2 We loop through the Match instances that are found on the MatchCollection returned by the Matches() method.
Step 3 We access the first group of each Match, and then print its value. This String could be stored in a List or used elsewhere.
Dim value As String = "('BH','BAHRAIN','Bahrain','BHR','048')"' Step 1: match data between single quotes hesitantly.
Dim result As MatchCollection = Regex.Matches(value, "'(.*?)'")
' Step 2: loop through Matches.
For Each m As Match In result
' Step 3: access first Group and its value.
Dim group = m.Groups(1)
Some notes. There are alternative methods you can use to accomplish this same task. A For-loop that appends the substrings to a List could work, or Regex.Split could be called.