#Caseware idea equation editor how to

Usually this pattern is then used by string searching algorithms for вЂfindвЂ™ or вЂfind and replaceвЂ™ operations on strings.вЂќ In the IDEA equation editor, the regular expression allows you to extract items such as a telephone number or email address that meet a pattern or extract records that donвЂ™t meet the pattern. Wikipedia says that a regular expression is вЂњa sequence of characters that define a search pattern.

#Caseware idea equation editor how to

Can you show me how to validate a U.S./Canada phone number and an email address in the equation editor?ДЄ: That is an excellent question! Being able to do regular expressions in the equation editor is one of IDEAвЂ™s hidden gems. IвЂ™m going to close them all.Q: IвЂ™ve heard that you can use regular expressions in IDEAвЂ™s equation editor. To close this file, you can click the X in the title tab, you can right-click on the title tab and select close or you can choose to select close all. The new database opens and is the active file. You can have a maximum of 50 extractions run against a database at one time.

You can keep creating extractions if you wish by clicking into the next available row and entering a new set of criteria. The equation is now visible in the Criteria line. My equation is fine so IвЂ™m going to click the Validate and Exit button on the toolbar and return to the Direct Extraction dialog box. Syntax errors are errors in equations things like missing operators, or an extra bracket. Type errors are when there is a data type mismatch, for example, trying to add or subtract numbers which are stored as character data types. If there is an error, the message box will indicate either a type error or syntax error. If your equation is correct, youвЂ™ll get a message indicating that it is indeed a valid equation. You can use the Equation Editor to validate your equation by clicking the Validate button. In order for IDEA to run the extraction, your equation must be valid. You donвЂ™t need to add currency indicators, or thousand separators here, just put in the number. Then enter the value you are comparing your data to.

Next, you either type or select the comparison indicator: Greater Than. Click enter to have IDEA fill in the value for you. As I type a list of potential fields is displayed. To generate that equation, you can either start by typing вЂњcredit limitвЂќ in the equation box, or you can scroll through the Field list and double click it. Remember, IвЂ™m looking for Customers who have a credit limit of 30,000 dollars or greater than can be expressed by this equation. The Equation Editor is launched by the button between File Name and Criteria that looks a little like a calculator. If you know the exact equation you need to get the filtered records you can go ahead and type it in. When you tab out of the name field you go to the Criteria field. You do that by clicking on the first row where it says Extraction1 and typing in a new name. Start by giving a name to your new database. This is the Direct Extraction dialog box. Next, click the Analysis tab and select Direct in the Extract group. To start, ensure Customer is the active file and Data is selected in the Properties window. For this example, I want to create a new database of Customers who have credit limits of 30,000 dollars or greater. This section will look at Direct Extraction.Дirect Extraction involves entering a set of criteria or conditions and all records which meet those conditions are extracted to a new file. Random sampling, as we have seen, is one method of extracting data.