Part 3. Built-In Characteristics and Functionality

Table of Contents

12. String Manipulation
1. String Comparison
1.1. The Compare Method
1.2. The ansi.strcmp method
2. String Search within a String Set
3. Substring Search
3.1. The Contains Method
3.2. The ansi.strstr Method
3.3. Searching at the Beginning or the End
3.4. Position of a Substring
3.5. The IsEMail Method
3.6. The IsDate Method
3.7. The IsNumeric Method
4. String Transformation
4.1. Highlighting Substrings
4.2. Character Case Modification
4.3. Substring Extraction
4.4. Substring Insertion and Elimination
4.5. Replacement
4.6. String to Array Conversion
4.7. Addition of Characters (Padding)
4.8. Removing Superfluous Space
5. String Encoding and Decoding
5.1. ISO 8859-1 Format Encoding
5.2. Encoding of Special Characters in a URL
6. Number to String Conversion
7. The Eval Function
13. File Management
1. Pathname Conventions
2. Creating and Opening Files
3. Input/Output Operations on Text Files
3.1. Writing Data in a File
3.2. Reading Data from a File
4. Renaming, Moving, Copying, and Deleting A File
4.1. Renaming a File
4.2. Moving a File
4.3. Copying a File
4.4. Deleting a File
5. Directory Operations
5.1. Creating a New Directory
5.2. Deleting a Directory
5.3. Renaming a Directory
5.4. Operations on the Content of a Directory
6. Alias Management
7. Modifying File and Directory Attributes
8. Other Properties of the File and Folder Classes
14. Date and Time Functionality
1. "Time Zero"
2. Date and Time Operations
3. Date and Time Formatting
15. Database Interaction
1. Database Connection
2. Direct Execution of an SQL Query
3. Processing the Result of an SQL Query
3.1. Modifying Cursor Position
3.2. Cursor Deletion
4. Preparation and Execution of SQL Queries
4.1. Dynamic Construction of SQL Strings
4.2. Using Parametric SQL Queries
5. Transactions
6. The Search Class
6.1. Search Class Properties
6.2. Construction of SQL Queries Using the ToSQL Method
16. Error Handling and Debugging
1. Error Messages
1.1. Emailing Errors to the Developer
2. Error Types in Biferno
3. How to Catch and Manage Error Conditions
4. How to Force an Error Condition
5. The Debug Instruction
6. User Class Errors