In the previous video, you understood the method and activities for string manipulation. In this video, you will understand regular expressions and the regular expressions builder wizard and studio. So, let's get started. Regular expression or RegEx is a specific search pattern that can be used to easily match, locate, and manage text. The studio contains a RegEx builder that simplifies the creation of regular expressions. The RegEx search capabilities and selectors enable the users to identify multiple target elements with a single search execution. RegEx can be used for input validation, string parsing, data scraping, and string manipulation. RegEx can be used for retrieving pieces of text that follow a certain pattern, such as an email address. Now, let's learn about the activities which have RegEx builder integrated with them. These are, first matches. This activity searches an input string for all occurrences and returns all the successful matches for the given expression. This activity can be used to retrieve all the entries and use them further. Second, Is match. This activity indicates whether the specified regular expression finds a match in the specified input string and returns only a true or false value. This activity can serve as a condition for another activity. And third, Replace. This activity replaces strings that match a regular expression pattern with a specified replacement string. This activity can be used for data quality purposes. As you know now about the activities that use the RegEx builder, let's take a look at the RegEx builder wizard. The Wizard helps ease the process of building and testing regular expression search criteria. The RegEx wizard can be opened from the body of any of these activities which are matches, is match or replace. Let's drag a matches activity. And click the configure regular expressions button to open the RegEx builder. The user interface of the regular builder has three sections. They are test text, type value and quantify IRS, full expression. In the test text field, the user can test the chosen search criteria against the text on which RegEx is applied. Before the text editor, the user can choose the RegEx expressions type, value and quantifiers. Doing so, highlights the findings in the test text editor. It simplifies building regular expressions by allowing the configuration of type, value, and quantifier. Once a condition is finalized, another one can be added. If there are more than one condition, the order in which they are applied can be configured as well. Let's have a look at type, value, and quantifies now. The type drop down allows searching for a given text or one expression from many. It can be configured to search only at the beginning or at the end. And also offers pre built expressions for emails, URL US states or US Phone numbers. Which are very useful in the case of standardized data. Some examples are, literal, digit, one of, not one of, anything, any word character, white space, starts with. The value field contains exactly the text that needs to be retrieved. The quantifier dropdown list enables the user to select the type of results that should be displayed. The dropdown has the following options. First, exactly that selects an exact amount of consecutive occurrences the user wants to find. For example, if the text being searched for is Hello and the quantify there is set to exactly two, the wizard finds any occurrences of Hello, Hello in the test text box. Second, any zero or more that highlights any number of consecutive found matches starting from zero. Third, at least one, one or more that highlights any number of consecutive found matches starting from one, fourth. Zero or one that only highlights a single consecutive occurrence of the term. Fifth, between X&Y times that highlights the number of consecutive occurrences selected. For example, searching for Hello and selecting between two and three times only highlights Hello, Hello and hello, Hello, Hello. The full expression text box at the bottom of the wizard, displays the current RegEx expression in its raw form. And that's it for this video. Next in this lesson, is a demonstration video on using RegEx builder. And another practice exercise on string manipulation. Thanks for watching. [MUSIC]
