Trim Function |  |
Remove trailing spaces from a string.
Namespace: XSharp.Core
Assembly: XSharp.Core (in XSharp.Core.dll) Version: 2.21
SyntaxRequest Example
View Source
cString with the trailing spaces removed.
If cString is a NULL_STRING or all spaces, Trim() returns a NULL_STRING.
Parameters
- cString
- Type: String
The string to trim.
Return Value
Type: StringcString with the trailing spaces removed.
If cString is a NULL_STRING or all spaces, Trim() returns a NULL_STRING.
Remarks
Trim() is used to format strings by deleting trailing spaces while concatenating strings.
This is typically the case with database fields which are stored in fixed-width format.
For example, you can use Trim() to concatenate first and last name fields to form a name string. Trim() is related to LTrim(), which removes leading spaces, and AllTrim(), which removes both leading and trailing spaces.
The inverse of AllTrim(), LTrim(), and Trim() are the PadC(), PadR(), and PadL() functions, which center, right-justify, or left-justify strings by padding them with fill characters.
This is typically the case with database fields which are stored in fixed-width format.
For example, you can use Trim() to concatenate first and last name fields to form a name string. Trim() is related to LTrim(), which removes leading spaces, and AllTrim(), which removes both leading and trailing spaces.
The inverse of AllTrim(), LTrim(), and Trim() are the PadC(), PadR(), and PadL() functions, which center, right-justify, or left-justify strings by padding them with fill characters.
Examples
This is a function in which Trim() formats city, state, and zip code fields for labels or form letters:
To complete the example the function, CityState(), displays a record from CUSTOMER.DBF:
X#
1FUNCTION CityState(cCity, cState, cZip) 2 RETURN Trim(cCity) + ", " ; 3 + Trim(cState) + " " + cZip
X#
1USE customer INDEX custname NEW 2SEEK "Kate" 3? CityState(City, State, ZipCode) 4// Athens, GA 10066
See Also