Fastest Way to Split Each Row in Column

Help Studio
1

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

image
image994×1015 56.4 KB

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:

image
image672×650 19.6 KB

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?

2

@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…