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?