data pull from website

[marwan1023]

How import data from website and get the column

Title Weekend Gross Weeks 

from link https://www.imdb.com/chart/boxoffice/?ref_=nv_ch_cht

[T_Willins · Accepted solution]

Hi @marwan1023,

Attached is a workflow that pulls the data you are looking for.  The first RegEx tokenizes the downloaded data for each part of the webpage html that starts with <tr> and ends with </tr>. The second RegEx parses each section of the code by unique identifiers for each data object you are looking for.   Let me know if you have questions.  If this answers your question, please mark this as an accepted solution.