Fastest Way to Split Each Row in Column

[AnnaDewitt]

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:

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?

[prasath17 (Guru)]

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

Formatting Excel Column

Hi @…You can try as shown below… [image] Add Data Column [image] Invoke Code dt.AsEnumerable().ToList().ForEach(Sub(row) row("Split")= system.text.RegularExpressions.Regex.match(row("Modified Yarn TC").ToString,"\d+(?=\/)")) Edit Arguments [image] Output [image] Hope this helps…

Hope this helps…