How to use matches to extract values using regex

Help
,
37

Hi,

I Have some problem to match all the values from a list(of Strings)?
I got with my regex only the last value from the list. and i want to get all values from list(of Strings).

I have a data table with data. I save the third column data into a list(of Strings) and want to split it in 2 columns. I have a for each loop that loops through the list(of Strings) and then I assign Data into the columns i want. But now I just get the last value from the list not all values. Have can this be done? .

Here is my two regex lines:

​System.Text.RegularExpressions.Regex.Match(item.Trim,“(.*)( g)”).Value

and:

System.Text.RegularExpressions.Regex.Match(item.Trim,“(?<=”+ExtractDataTable.Rows(list(of String).IndexOf(item))(“Column3”).ToString+“)(.*)”).Value

Thank you in advance for your help.

Regard, Mikael