I have an Excel spreadsheet with a list of movies and tv shows. I have a script that will connect to [login to view URL] and pull meta information for movies based on the content in Cell A. The problem is, the script is unable to pull metadata for TV shows, and it also has some trouble with the titles and sometimes does not recognize it if the text isn't perfect.
Here is a sample of some of the titles.
28 Weeks Later
2 Guns 2013
30,000 Leagues Under The Sea 2007
300 Rise of an Empire 2014
30 Minutes Or Less 2011
30 Rock S01E01 Pilot
30 Rock S01E02 The Aftermath
What I need is the script modified so that it IF the title contains season and episode information it instead searches omdbapi using that information transposed from the title into something omdbapi can recognize.
I don't know the syntax but it would logically be something like:
IF title contains "s##*e##" then use "t=%s&season=%s&episode=%s" instead of searching by title only.
Here is a sample of a way to connect to the omdbapi for episode and season information.
"String url = "[login to view URL]";
String charset = "UTF-8";
String title = "Game of Thrones";
String season = "5";
String episode "5";
String query = [login to view URL]("t=%s&season=%s&episode=%s",
[login to view URL](title, charset),
[login to view URL](season, charset),
[login to view URL](episode, charset),);
URLConnection connection = new URL(url + "?" + query).openConnection();
[login to view URL]("Accept-Charset", charset);
InputStream response = [login to view URL]();
// Do some stuff with the data"
Hi there, I understood the problem and can come up with an 'elegant' (efficient + simple) solution. Looking forward to your contact, Grunty.
Bu iş için 10 freelancer ortalamada $49 teklif veriyor
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex Daha Fazla
Hi, I am interested in your offer. Let me know more details about this work. I will start working immediately :) Br;
"Greetings! According to your stated project description you need an excel exper. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your Daha Fazla
I've been working in working with .Net Framework and Microsoft products and services for the past few years. I am trained in design and development of Microsoft Office Add-in using VSTO framework C#. As per your requir Daha Fazla
I have extensive experience using Excel in my past work. As a Statistics TA that used Excel to manage to manipulate and analyze data, I already have an idea of what needs done. Although it seems that you might have som Daha Fazla
I have an Excel spreadsheet with a list of movies and tv shows. I have a script that will connect to [login to view URL] and pull meta information for movies based on the content in Cell A. The problem is, the script is unable Daha Fazla
I have 5 years of experience in excel vba webscraping also i offer you sample of the data.