2.0
Table Of Contents
- Introduction
- Installation and Setup
- Tutorials
- Views and Form Usage
- OmniForm Procedures
- Designing a Form
- The Design Process
- The Design View Toolbars
- Creating Objects
- General Creation Guidelines
- Creating a Text Object
- Creating a Line Object
- Creating an Oval Object
- Creating a Rectangle Object
- Creating a Graphic Object
- Creating a Fill Text Object
- Creating a Comb Object
- Creating a Check Box Object
- Creating a Circle Text Object
- Creating a Table Object
- Creating a Fill Graphic Object
- Defining Objects
- Changing Object Appearance
- Redesigning Your Form
- Using the Scrapbook
- Inserting OLE Objects in a Form
- Filling a Form
- Managing an OmniForm Database
- Using Calculations
- Calculation Overview
- Operators
- Functions
- Abs (Absolute Value)
- Avg (Average)
- Date (Current Date)
- DayName
- DayOfMonth
- DayOfWeek
- DayOfYear
- Exp (Exponentiation)
- FV (Future Value)
- Hour
- If
- Int (Integer)
- Left
- Length
- Ln (Natural Logarithm)
- Log (Base 10 Logarithm)
- Lower
- Max (Maximum)
- Middle
- Min (Minimum)
- Minute
- Mod (Modulus (Remainder))
- Month
- MonthName
- Pi
- PMT (Payment)
- Position
- Proper
- PV (Present Value)
- RecordCount
- Replace
- Replicate
- Right
- Round
- Second
- Sign
- Sqrt (Square Root)
- Sum
- Time
- Trim
- Trunc (Truncate)
- Upper
- Year
- Functions — Quick Reference
- Functions Sorted by Type
- Technical Information
- Glossary
Functions
Using Calculations - 250
Trim
The Trim function returns a given string with all leading, trailing, and
extra blank spaces removed.
Usage Example
Trim([str1])
If the field [str1] = Jane Doe
Then the calculation Trim([str1]) returns Jane Doe
In the example below, the
Supervisor 1
field or
Supervisor 2
field is placed
in the
Manager
field depending on which box is checked. The name is
trimmed of all extra blank spaces.
Trunc (Truncate)
The Trunc function returns the value of a number or numeric expression
truncated to the specified number of decimal places in the second
parameter.
Usage Example
Trunc([num1],num of decimal places)
If the field [num1] = 3.1415926
Then the calculation Trunc([num1],4) returns 3.1415
In a different example below, the sales are summed and placed in the
All
Sales
field. The value is truncated down to 10 cents.