Vireblc
vireblc allows you to suppress leading, trailing, or internal spaces of a string character or CLOB expression.
vireblc(STRING_EXPR,INT_OPTION)STRING_EXPR is an expression returning a string or CLOB value.INT_OPTION is an integer expression that returns a value between 0 and 5.# Different options used# I=0 will return "!Test vireb !"# I=1 will return "! Test vireb!"# I=2 will return "!Test vireb!"# I=3 will return "!Test!"# I=4 will return "!Testvireb!"# I=5 will return "! Test vireb !"For I = 0 To 5RESULT(I)="!"+vireblc(" Test vireb ", I)+"!"Next Ivireblc suppresses spaces from a CLOB or a string according to the following options:
| Option | Effect |
|---|---|
| 0 | Suppresses the leading spaces. |
| 1 | Suppresses the trailing spaces. |
| 2 | Suppresses the leading spaces and the trailing spaces. |
| 3 | Suppresses the leading spaces, and cuts the string at the next space ("one word" cutting). |
| 4 | Suppresses all the spaces. |
| 5 | Suppresses consecutive spaces by a unique space. |
The formatting options v0 to v5 for format$ function use the same values for suppressing the spaces when formatting a value.
| Error code | Description |
|---|---|
| 10 | The first argument is not a string, or the second argument is not an integer. |
| 50 | The second argument is not in [0,5] range. |
Char, format$, left$, mid$, right$, seg$.