After finishing these pages you will have a complete application which will work for either console or desktop platform. You will be utilizing three languages - C#,VB.Net and Java for creating this application. Each chapter covers a single language and either the desktop or console application coded in that language (Java does not natively allow a console application, so it includes only Desktop). For console program automation purposes, we will be using an Excel sheet and VBA coding. Using the desktop application allows for more flexibility in web page processing, with entry fields for beginning and ending text along with DIVs and other processing options. Enjoy this learning experience.
This list includes some of the types/commands and the languages that use them
WebResponse, WebRequest, HttpWebRequest, StreamReader (C#/VB)
GetResponse, Regex.Replace, String.Replace, IndexOf (C#/VB)
Substring, ReadLine, Trim, WriteLine (C#/VB)
EndsWith, AddRange, ReadToEnd, Count (C#/VB)
GetCommandLineArgs, GetResponseStream (VB)
getText, endsWith, split, length, openConnection (Java)
toString, BufferedReader, getSelectedIndex, replaceAll (Java)
isEmpty, substring,indexOf, readLine, PrintWriter, write (Java)
Why would you want to work with the same program in multiple languages? A simple answer to this is "versatility." You may come across a need for Java where a .Net-based language just won't work. A perfect example of this is Windows versus Linux web hosting. If you have designed a .Net program and placed it on your site based on Windows, it will work beautifully. If you then change the hosting plan to Linux, the .Net program will not work without some tweaking or an interpreter. If that were written in Java, however, it would have moved over fine.
Why would you want a web site text extraction program? Well, if you had a need to capture the main text from a few web pages, this would be too much trouble. If you are migrating a web site designed in ASP.NET into another format, maybe a CMS, this approach can be quite useful. If you have 1,000 pages in the site and all are similarly structured, it may take a week for a single person to manually copy and paste the body text from these pages. Using the automated approach, with a pause between each page for accuracy purposes, approximately 700 pages per hour can be processed. That equates to a tremendous labor savings.
Stephen J. Link is a “computer guy” by profession, an author by hobby, and a Layman in the study of God’s Word. He has a computer support book entitled “Link Em Up On Outlook” that was published in 2004 as a paperback (renamed to "Power Outlook" in reprint). He also has over 125 articles covering various topics published on his own blog and independent sites. Various Books have been published covering a number of topics. As a programmer, he has a unique approach to help you master the ability to create the code to automate processes and add efficiency to your client's or employer's processes. Along this journey, you will have an opportunity to "dabble" in four different languages - CSharp, VB.Net, Java and Visual Basic for Applications.
Why use the word "dabble?" Because there is no way, in a single program, to squeeze all of the power that can be utilized in any programming language. Yes, you will see four languages and two platforms, but they all create the same functioning program. As with all software, web sites and anything else you may develop, it is never totally complete. As you are working through the programs, or after finishing them, you are likely to see improvements that could have been made. That is the beauty of computer programming - the only limits are imposed by your imagination and amount of funding.
Let's discuss browser compatibility. Does your target audience use a current version of Firefox or Chrome? If so, you are all set to download and run this app. Do you run the most current version of Internet Explorer? You may want to switch since complete HTML5 compatibility seems to be fleeting for IE.
All programs and code snippets in this book are available as interactive samples in LINQPad. You can edit these samples and instantly see the results without needing to set up projects in Visual Studio. Written by the authors of C# 7.0 in a Nutshell, this pocket reference covers C# 7.0 without skimping on detail, including:All of C#’s fundamentalsFeatures new to C# 7.0, including tuples, pattern matching, and deconstructorsAdvanced topics: operator overloading, type constraints, iterators, nullable types, operator lifting, lambda expressions, and closuresLINQ: sequences, lazy execution, standard query operators, and query expressionsUnsafe code and pointers, custom attributes, preprocessor directives, and XML documentation
All the topics in this book are elaborated in simple manner for easy understanding. Each and every topic in this book is covered with detailed illustrations followed by output.
What you will learn in this book
1) Introduction to Excel VBA-
2) Declaring Variables
3) Working with Ranges
4) If…Else Statements
5) Select Case Statements
6) For Next Statements
7) Do Loops
8) Operators in VBA
9) Understanding the VB Editor
10) Function Procedures
11) MsgBox and InputBox Functions
12) String Functions
13) Information Functions
14) Working with Internet Explorer