TRIM
Trims spaces off the end of a character expression.
Reporting Area(s)
General
Required Parameters
- Field to be trimmed (i.e. cocrsenm, nmfirm, rgstatus)
Optional Parameters
- Numeric value to determine case sensitivity when using parameter 3. If 0, search is case-sensitive. If 1, search is case-insensitive.
- Character string to remove (i.e. "
<p>
").
Example(s)
TRIM(cocrsenm) returns course name without any trailing spaces
TRIM(cadesc2,1,"<p>
") returns cadesc2 with the <p>
tag removed from the end of the field.
Notes
Standard FoxPro Function
Also, ALLTRIM(fieldname) trims spaces off of left and right sides, LTRIM(fieldname) trims spaces off of Left side of expression