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:

Here,

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:

image

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…