User`s guide

APPENDIX A Function Reference
User’s Guide 179
uCap(‘fArmeR, ASTROnaut’) // returns ‘Farmer,
Astronaut’
uCap(‘the first weekend’) // returns ‘The First Weekend’
uConcat, uCon
Description Returns the concatenation of all input parameters.
Syntax string uConcat(params, ...)
Parameters
params
A list of expressions or values of any datatype.
Examples To concatenate a string:
uConcat(“For “, 3, “ years.”) returns “For 3 years.”
uJoin
Description Concatenates a delimited string respecting NULL values. All parameters are
concatenated using the value in the first parameter as delimiter. If the second
parameter is not zero, empty parameters are treated as normal; otherwise, they
are ignored.
Error codes: none
Syntax string uJoin(delimiter, allowEmpty, params, ...)
Parameters
string delimiter
Delimiter to be used between all other string parts.
number allowEmpty
Flag (0/1) indicating if we allow empty fields.
string params
List of strings to concatenate.
Examples To create a delimited string:
uJoin("-", 1, "James", "", "Tiberius", "Kirk") //
returns "James--Tiberius-Kirk"
uJoin("-", 0, "James", "", "Tiberius", "Kirk") //