Utils

Unknown macro: {td}

getUnicodeCharacter(unicodeCharacterNumber)
Returns a string containing the character for the unicode number.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

hasRecords(foundset_or_record, [qualifiedRelationString])
Returns true if the (related)foundset exists and has records.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

isMondayFirstDayOfWeek()
Returns true when Monday is the first day of the week for your current locale setting.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

numberFormat(number, digitsOrFormat)
Format a number to specification (or to have a defined fraction).

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringEscapeMarkup(textString, [escapeSpaces], [convertToHtmlUnicodeEscapes])
Returns the escaped markup text (HTML/XML).

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringFormat(text_to_format, parameters_array)
Formats a string according to format specifiers and arguments.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringIndexReplace(textString, i_start, i_size, replacement_text)
Replaces a portion of a string with replacement text from a specfied index.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringInitCap(text)
Returns all words starting with capital chars.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringLeft(textString, i_size)
Returns a string with the requested number of characters, starting from the left.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringLeftWords(text, numberof_words)
Returns the number of words, starting from the left.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringMD5HashBase16(textString)
Returns the md5 hash (encoded as base16) for specified text.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringMD5HashBase64(textString)
Returns the md5 hash (encoded as base64) for specified text.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringMiddle(textString, i_start, i_size)
Returns a substring from the original string.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringMiddleWords(text, i_start, numberof_words)
Returns a substring from the original string.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringPatternCount(textString, searchString)
Returns the number of times searchString appears in textString.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringPosition(textString, searchString, i_start, i_occurrence)
Returns the position of the string to seach for, from a certain start position and occurrence.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringReplace(text, search_text, replacement_text)
Replaces a portion of a string with replacement text.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringReplaceTags(text, foundset_or_record)
Returns the text with % %tags%% replaced, based on provided record or foundset.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringRight(textString, i_size)
Returns a string with the requested number of characters, starting from the right.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringRightWords(text, numberof_words)
Returns the number of words, starting from the right.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringToNumber(textString)
Filters characters out of from a string and leaves digits, returns the number.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringTrim(textString)
Returns the string without leading or trailing spaces.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

stringWordCount(textString)
Returns the number of words in the text string.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Date

Unknown macro: {td}

timestampToDate(date)
Returns a datestamp from the timestamp (sets hours,minutes,seconds and milliseconds to 0).

Unknown macro: {table}

{column:padding=0px|width=100%}{column}

Unknown macro: {tr}

Unknown macro: {th}

Method Details

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

dateFormat

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Object

Unknown macro: {span}

dateFormat

Unknown macro: {span}

(date, format)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Format a date object to a text representation or a parses a datestring to a date object.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} date – the date as text or date object
{Object} format – the format to output or parse the to date

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Object – the date as text or date object

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

var parsedDate = utils.dateFormat(datestring,'EEE, d MMM yyyy HH:mm:ss'); 

var formattedDateString = utils.dateFormat(dateobject,'EEE, d MMM yyyy HH:mm:ss');

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

getUnicodeCharacter

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

getUnicodeCharacter

Unknown macro: {span}

(unicodeCharacterNumber)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns a string containing the character for the unicode number.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Number} unicodeCharacterNumber – the number indicating the unicode character

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – a string containing the unicode character

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns a big dot
var dot = utils.getUnicodeCharacter(9679);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

hasRecords

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

hasRecords

Unknown macro: {span}

(foundset_or_record, [qualifiedRelationString])

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns true if the (related)foundset exists and has records.
Another use is, to pass a record and qualified relations string to test multiple relations/foundset at once

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

foundset_or_record – the foundset or record to be tested
[qualifiedRelationString] – the qualified relation string to reach a related foundset if a record is passes as first paramter

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Boolean – true if exists

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//test the orders_to_orderitems foundset 
if (elements.customer_id.hasRecords(orders_to_orderitems))
{
	//do work on relatedFoundSet
}
//test the orders_to_orderitems.orderitems_to_products foundset to be reached from the current record 
//if (elements.customer_id.hasRecords(foundset.getSelectedRecord(),'orders_to_orderitems.orderitems_to_products'))
//{
//	//do work on deeper relatedFoundSet
//}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

isMondayFirstDayOfWeek

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

isMondayFirstDayOfWeek

Unknown macro: {span}

()

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns true when Monday is the first day of the week for your current locale setting.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Boolean – true if Monday is first day of the week in current locale

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

if(utils.isMondayFirstDayOfWeek())
{
//a date calculation
}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

numberFormat

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

numberFormat

Unknown macro: {span}

(number, digitsOrFormat)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Format a number to specification (or to have a defined fraction).

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} number – the number to format
{Object} digitsOrFormat – the format or digits

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the resulting number in text

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

var textalNumber = utils.numberFormat(16.749, 2); //returns 16.75
var textalNumber2 = utils.numberFormat(100006.749, '#,###.00'); //returns 100,006.75

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringEscapeMarkup

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringEscapeMarkup

Unknown macro: {span}

(textString, [escapeSpaces], [convertToHtmlUnicodeEscapes])

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns the escaped markup text (HTML/XML).

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

textString – the text to process
[escapeSpaces] – boolean indicating to escape spaces
[convertToHtmlUnicodeEscapes] – boolean indicating to use unicode escapes

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the escaped text

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

var escapedText = utils.stringEscapeMarkup('<html><body>escape me</body></html>')

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringFormat

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringFormat

Unknown macro: {span}

(text_to_format, parameters_array)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Formats a string according to format specifiers and arguments.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{String} text_to_format – the text to format
{Object} parameters_array – the array with parameters

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the formatted text

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

// the  format specifier has the syntax: %[argument_index$][flags][width][.precision]conversion
// argument index is 1$, 2$ ...
// flags is a set of characters that modify the output format
// typical values: '+'(The result will always include a sign), ','(The result will include locale-specific grouping separators)
// width is a non-negative decimal integer indicating the minimum number of characters to be written to the output
// precision is a non-negative decimal integer usually used to restrict the number of characters
// conversion is a character indicating how the argument should be formatted
// typical conversion values: b(boolean), s(string), c(character), d(decimal integer), f(floating number), t(prefix for date and time)
// Date/Time Conversions (used after 't' prefix): 
		// 'H' 	Hour of the day for the 24-hour clock, formatted as two digits with a leading zero as necessary i.e. 00 - 23. 
		// 'I' 	Hour for the 12-hour clock, formatted as two digits with a leading zero as necessary, i.e. 01 - 12. 
		// 'k' 	Hour of the day for the 24-hour clock, i.e. 0 - 23. 
		// 'l' 	Hour for the 12-hour clock, i.e. 1 - 12. 
		// 'M' 	Minute within the hour formatted as two digits with a leading zero as necessary, i.e. 00 - 59. 
		// 'S' 	Seconds within the minute, formatted as two digits with a leading zero as necessary, i.e. 00 - 60 ("60" is a special value required to support leap seconds).
		// 'L' 	Millisecond within the second formatted as three digits with leading zeros as necessary, i.e. 000 - 999.
		// 'p' 	Locale-specific morning or afternoon marker in lower case, e.g."am" or "pm". Use of the conversion prefix 'T' forces this output to upper case. 
		// 'z' 	RFC 822 style numeric time zone offset from GMT, e.g. -0800.
		// 'Z' 	A string representing the abbreviation for the time zone.
		// 'B' 	Locale-specific full month name, e.g. "January", "February".
		// 'b' 	Locale-specific abbreviated month name, e.g. "Jan", "Feb". 
		// 'h' 	Same as 'b'. 
		// 'A' 	Locale-specific full name of the day of the week, e.g. "Sunday", "Monday" 
		// 'a' 	Locale-specific short name of the day of the week, e.g. "Sun", "Mon" 
		// 'C' 	Four-digit year divided by 100, formatted as two digits with leading zero as necessary, i.e. 00 - 99 
		// 'Y' 	Year, formatted as at least four digits with leading zeros as necessary, e.g. 0092 equals 92 CE for the Gregorian calendar. 
		// 'y' 	Last two digits of the year, formatted with leading zeros as necessary, i.e. 00 - 99.
		// 'j' 	Day of year, formatted as three digits with leading zeros as necessary, e.g. 001 - 366 for the Gregorian calendar. 
		// 'm' 	Month, formatted as two digits with leading zeros as necessary, i.e. 01 - 13. 
		// 'd' 	Day of month, formatted as two digits with leading zeros as necessary, i.e. 01 - 31 
		// 'e' 	Day of month, formatted as two digits, i.e. 1 - 31.

		// common compositions for date/time conversion
		// 'R' 	Time formatted for the 24-hour clock as "%tH:%tM" 
		// 'T' 	Time formatted for the 24-hour clock as "%tH:%tM:%tS". 
		// 'r' 	Time formatted for the 12-hour clock as "%tI:%tM:%tS %Tp". The location of the morning or afternoon marker ('%Tp') may be locale-dependent. 
		// 'D' 	Date formatted as "%tm/%td/%ty". 
		// 'F' 	ISO 8601 complete date formatted as "%tY-%tm-%td". 
		// 'c' 	Date and time formatted as "%ta %tb %td %tT %tZ %tY", e.g. "Sun Jul 20 16:17:00 EDT 1969".

utils.stringFormat('%s Birthday: %2$tm %2$te,%2$tY',new Array('My',new Date(2009,0,1))) // returns My Birthday: 01 1,2009
utils.stringFormat('The time is: %1$tH:%1$tM:%1$tS',new Array(new Date(2009,0,1,12,0,0))) // returns The time is: 12:00:00
utils.stringFormat('My %s: %2$.0f, my float: %2$.2f',new Array('integer',10)) // returns My integer: 10, my float: 10.00
utils.stringFormat('Today is: %1$tc',new Array(new Date())) // returns current date/time as:  Today is: Fri Feb 20 14:15:54 EET 2009
utils.stringFormat('Today is: %tF',new Array(new Date())) // returns current date as: Today is: 2009-02-20

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringIndexReplace

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringIndexReplace

Unknown macro: {span}

(textString, i_start, i_size, replacement_text)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Replaces a portion of a string with replacement text from a specfied index.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process
{Object} i_start – the start index to work from
{Object} i_size – the size of the text to replace
{Object} replacement_text – the replacement text

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the changed text string

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'this was a test'
var retval = utils.stringIndexReplace('this is a test',6,2,'was');

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringInitCap

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringInitCap

Unknown macro: {span}

(text)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns all words starting with capital chars.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} text – the text to process

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the changed text

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'This Is A Test'
var retval = utils.stringInitCap('This is A test');

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringLeft

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringLeft

Unknown macro: {span}

(textString, i_size)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns a string with the requested number of characters, starting from the left.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process
{Object} i_size – the size of the text to return

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the result text string

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'this i'
var retval = utils.stringLeft('this is a test',6);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringLeftWords

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringLeftWords

Unknown macro: {span}

(text, numberof_words)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns the number of words, starting from the left.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} text – to process
{Object} numberof_words – to return

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the string with number of words form the left

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'this is a'
var retval = utils.stringLeftWords('this is a test',3);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringMD5HashBase16

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringMD5HashBase16

Unknown macro: {span}

(textString)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns the md5 hash (encoded as base16) for specified text.

NOTE: MD5 (Message-Digest Algorythm 5) is a hash function with a 128-bit hash value, for more info see: http://en.wikipedia.org/wiki/MD5

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the resulting hashString

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

var hashed_password = utils.stringMD5HashBase16(user_password)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringMD5HashBase64

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringMD5HashBase64

Unknown macro: {span}

(textString)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns the md5 hash (encoded as base64) for specified text.

NOTE: MD5 (Message-Digest Algorythm 5) is a hash function with a 128-bit hash value, for more info see: http://en.wikipedia.org/wiki/MD5

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the resulting hashString

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

var hashed_password = utils.stringMD5HashBase64(user_password)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringMiddle

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringMiddle

Unknown macro: {span}

(textString, i_start, i_size)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns a substring from the original string.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process
{Object} i_start – the start index to work from
{Object} i_size – the size of the text to return

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the result text string

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'his'
var retval = utils.stringMiddle('this is a test',2,3);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringMiddleWords

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringMiddleWords

Unknown macro: {span}

(text, i_start, numberof_words)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns a substring from the original string.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} text – to process
{Object} i_start – start word index
{Object} numberof_words – the word count to return

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the string with number of words form the left and

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'is a'
var retval = utils.stringMiddleWords('this is a test',2,2);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringPatternCount

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringPatternCount

Unknown macro: {span}

(textString, searchString)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns the number of times searchString appears in textString.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process
{Object} searchString – the string to search

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Number – the occurrenceCount that the search string is found in the text

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 2 as count
var count = utils.stringPatternCount('this is a test','is');

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringPosition

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringPosition

Unknown macro: {span}

(textString, searchString, i_start, i_occurrence)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns the position of the string to seach for, from a certain start position and occurrence.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process
{Object} searchString – the string to search
{Object} i_start – the start index to search from
{Object} i_occurrence – the occurrence

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Number – the position

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 4 as position
var pos = utils.stringPosition('This is a test','s',1,1)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringReplace

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringReplace

Unknown macro: {span}

(text, search_text, replacement_text)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Replaces a portion of a string with replacement text.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} text – the text to process
{Object} search_text – the string to search
{Object} replacement_text – the replacement text

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the changed text string

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'these are cow 1 and cow 2.'
var retval = utils.stringReplace('these are test 1 and test 2.','test','cow');

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringReplaceTags

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringReplaceTags

Unknown macro: {span}

(text, foundset_or_record)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns the text with % %tags%% replaced, based on provided record or foundset.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} text – the text tags to work with
{Object} foundset_or_record – the foundset or record to be used to fill in the tags

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the text with replaced tags

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//Next line places a string in variable x, whereby the tag(% %TAG%%) is filled with the value of the database column 'company_name' of the selected record.
var x = utils.stringReplaceTags("The companyName of the selected record is % %company_name%% ", foundset)
//var otherExample = utils.stringReplaceTags("The amount of the related order line % %amount%% ", order_to_orderdetails);
//var recordExample = utils.stringReplaceTags("The amount of the related order line % %amount%% ", order_to_orderdetails.getRecord(i);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringRight

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringRight

Unknown macro: {span}

(textString, i_size)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns a string with the requested number of characters, starting from the right.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process
{Object} i_size – the size of the text to return

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the result text string

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'a test'
var retval = utils.stringLeft('this is a test',6);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringRightWords

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringRightWords

Unknown macro: {span}

(text, numberof_words)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns the number of words, starting from the right.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} text – to process
{Object} numberof_words – to return

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the string with number of words form the right

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'is a test'
var retval = utils.stringRightWords('this is a test',3);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringToNumber

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringToNumber

Unknown macro: {span}

(textString)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Filters characters out of from a string and leaves digits, returns the number.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Number – the resulting number

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns '65567'
var retval = utils.stringToNumber('fg65gf567');

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringTrim

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

stringTrim

Unknown macro: {span}

(textString)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Returns the string without leading or trailing spaces.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{Object} textString – the text to process

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

String – the resulting trimmed string

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

//returns 'text'
var retval = utils.stringTrim('   text   ');

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

stringWordCount

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}