Nevron Vision for SharePoint Documentation
Text Functions
Syntax Description Example
ARGB(nA, nR, nG, nB) Returns a valid color string in ARGB format. All color components are automatically clamped to the [0:255] range. ARGB(128, 255, 0, 0)
Returns: "(128,255,0,0)" 
CHAR(nNumber) Returns the character for a number. The resulting string is one character in length. CHAR(9)
Returns: tab character
FORMAT(var[,sFormat][,sCulture])

Returns a formatted string representing a variant value. If format is not specified the default system format is used. If format is specified you can also specify a culture. If culture is not specified the default current culture is used.

For number variants the format string should be a number format string. See Numeric Format Strings.

For date time variants the format string should be a date time format string. See: Date Time Format Strings.

Also see Culture Table for a list of culture names that you can use.

(assuming current culture is en-US")

FORMAT(10)
Returns: "10"

FORMAT(0.255555, "p")
Returns: 25.56 %

FORMAT(1000, "c")
Returns: $1,000.00

FORMAT(1000,"c","en-GB")
Returns: £1,000.00

FORMAT(DATETIME("2008-09-15T09:30:41.77"),"d")
Returns: 9/15/2008

FORMAT(DATETIME("2008-09-15T09:30:41.77"),"d","en-GB")
Returns: 15/9/2008
LEN(sString) Returns the number of characters in a text string. LEN("Hello World")
Returns: 11
JOIN(arr, sDelimiter) Returns a string variant, which represents the concatenation of the string representations of the variants contained in the array, delimited with delimiter. JOIN(ARRAY("Hello","World"), ";")
Returns: Hello;World
LIKE(sString, sPattern)

Returns true if the pattern was found at least once in the string. The pattern is a regular expression. See:

Regular Expressions on MSDN

LIKE("Hello World", "ello")
Returns: true

LIKE("Hello World", "elllo")
Returns: false
LOWER(sString) Returns a string converted to lowercase. LOWER("Hello World")

Returns: "hello world"
REPLACE(sString, sOldText, sNewText) Replaces all occurrences of old text in a string with the specified new text. REPLACE("Hello World", "Hello", "Beautiful")

Returns: "Beautiful World"
RGB(nR, nG, nB) Returns a valid color string in RGB format. All color components are automatically clamped to the [0:255] range. RGB(255, 0, 0)
Returns: "(255,0,0)" 
SPLIT(sString, sSeparator[, bRemoveEmpty])

Splits the string, by the specified separator. Optionally you can specify whether empty strings are to be removed - by default they are not removed. Returns an array of strings.

SPLIT("Hello World", " ")

Returns: an array containing "Hello" and "World"

SPLIT(ARRAY("Hello World", "Hello World"), " ")

Returns: an array containing "Hello", "World", "Hello", "World"

STRSAME(sString1, sString2[, ignoreCase]) Returns true if the string are the same. Otherwise returns false. The optional ignoreCase argument indicates whether to perform case-insensitive comparison (by default it is false).

STRSAME("Hello", "hello")
Returns: false

STRSAME("Hello", "hello", true)
Returns: true

TRIM(sString) Removes all space from string except for single spaces between words. TRIM(" Hello World ")
Returns: "Hello World"
UPPER(sString) Returns a string converted to uppercase. UPPER("Hello World")
Returns: "HELLO WORLD"

 

 


©2016. Nevron Software LLC.

Send Feedback