Fastest Way to Split Each Row in Column

Hello. I am trying to export and prepare .csv file from film website. My extracted data table is like below:

I want to seperate film titles to a column, years to another column, rating another column and url another column.

To do that, I used this structure:


I used Split(CritickerExportedList.Rows(Counter)(0).ToString, “(”)(0).ToString.Trim for get title,

System.Text.RegularExpressions.Regex.Match(CritickerExportedList.Rows(Counter)(0).ToString,“(?<=()\d+(?=))”).Value for get years.

I get the result that I want like below:


But my list includes more than 4000 films and program runs so slow. After 10 minutes, the program was around 2000 film.

Is there any faster way to do this?

@AnnaDewitt - You can try invoke code method, please refer this below post where the column has been split similar to what you are trying above…

Hope this helps…