Page History

Hidden

DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE

HTML Table

class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Object

Table Cell (td)
#dateFormat(date, format) Format a date object to a text representation or a parses a datestring to a date object.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getUnicodeCharacter(unicodeCharacterNumber) Returns a string containing the character for the unicode number.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#numberFormat(number, digitsOrFormat) Format a number to specification (or to have a defined fraction).

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringInitCap(text) Returns all words starting with capital chars.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringLeftWords(text, numberof_words) Returns the number of words, starting from the left.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringMD5HashBase16(textString) Returns the md5 hash (encoded as base16) for specified text.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringMD5HashBase64(textString) Returns the md5 hash (encoded as base64) for specified text.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringMiddle(textString, i_start, i_size) Returns a substring from the original string.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringMiddleWords(text, i_start, numberof_words) Returns a substring from the original string.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#stringPatternCount(textString, searchString) Returns the number of times searchString appears in textString.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringReplace(text, search_text, replacement_text) Replaces a portion of a string with replacement text.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringReplaceTags(text, foundset_or_record_or_form) Returns the text with %%tags%% replaced, based on provided record or foundset or form.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringRightWords(text, numberof_words) Returns the number of words, starting from the right.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#stringTrim(textString) Returns the string without leading or trailing spaces.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#stringWordCount(textString) Returns the number of words in the text string.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Date

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

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	dateFormat
class	node

Table Row (tr)

id	name

Table Cell (td)
dateFormat

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Object

Span

style	float: left; font-weight: bold;
id	iets

dateFormat

Span

style	float: left;
id	iets

(date, format)

Table Row (tr)

id	des

Table Cell (td)
Format a date object to a text representation or a parses a datestring to a date object.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} date – the date as text or date object {Object} format – the format to output or parse the to date

Table Row (tr)

id	ret

Table Cell (td)
Returns Object – the date as text or date object

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getUnicodeCharacter
class	node

Table Row (tr)

id	name

Table Cell (td)
getUnicodeCharacter

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getUnicodeCharacter

Span

style	float: left;
id	iets

(unicodeCharacterNumber)

Table Row (tr)

id	des

Table Cell (td)
Returns a string containing the character for the unicode number.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Number} unicodeCharacterNumber – the number indicating the unicode character

Table Row (tr)

id	ret

Table Cell (td)
Returns String – a string containing the unicode character

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	hasRecords
class	node

Table Row (tr)

id	name

Table Cell (td)
hasRecords

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Boolean

Span

style	float: left; font-weight: bold;
id	iets

hasRecords

Span

style	float: left;
id	iets

(foundset_or_record, [qualifiedRelationString])

Table Row (tr)

id	des

Table Cell (td)
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

Table Row (tr)

id	prs

Table Cell (td)
Parameters 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

Table Row (tr)

id	ret

Table Cell (td)
Returns Boolean – true if exists

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//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
//}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	isMondayFirstDayOfWeek
class	node

Table Row (tr)

id	name

Table Cell (td)
isMondayFirstDayOfWeek

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Boolean

Span

style	float: left; font-weight: bold;
id	iets

isMondayFirstDayOfWeek

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

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

Table Row (tr)

id	ret

Table Cell (td)
Returns Boolean – true if Monday is first day of the week in current locale

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	numberFormat
class	node

Table Row (tr)

id	name

Table Cell (td)
numberFormat

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

numberFormat

Span

style	float: left;
id	iets

(number, digitsOrFormat)

Table Row (tr)

id	des

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

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} number – the number to format {Object} digitsOrFormat – the format or digits

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the resulting number in text

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringEscapeMarkup
class	node

Table Row (tr)

id	name

Table Cell (td)
stringEscapeMarkup

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringEscapeMarkup

Span

style	float: left;
id	iets

(textString, [escapeSpaces], [convertToHtmlUnicodeEscapes])

Table Row (tr)

id	des

Table Cell (td)
Returns the escaped markup text (HTML/XML).

Table Row (tr)

id	prs

Table Cell (td)
Parameters textString – the text to process {Boolean} [escapeSpaces] – indicating to escape spaces {Boolean} [convertToHtmlUnicodeEscapes] – indicating to use unicode escapes

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the escaped text

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringFormat
class	node

Table Row (tr)

id	name

Table Cell (td)
stringFormat

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringFormat

Span

style	float: left;
id	iets

(text_to_format, parameters_array)

Table Row (tr)

id	des

Table Cell (td)
Formats a string according to format specifiers and arguments.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {String} text_to_format – the text to format {Object} parameters_array – the array with parameters

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the formatted text

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

// 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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringIndexReplace
class	node

Table Row (tr)

id	name

Table Cell (td)
stringIndexReplace

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringIndexReplace

Span

style	float: left;
id	iets

(textString, i_start, i_size, replacement_text)

Table Row (tr)

id	des

Table Cell (td)
Replaces a portion of a string with replacement text from a specfied index.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {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

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the changed text string

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringInitCap
class	node

Table Row (tr)

id	name

Table Cell (td)
stringInitCap

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringInitCap

Span

style	float: left;
id	iets

(text)

Table Row (tr)

id	des

Table Cell (td)
Returns all words starting with capital chars.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} text – the text to process

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the changed text

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringLeft
class	node

Table Row (tr)

id	name

Table Cell (td)
stringLeft

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringLeft

Span

style	float: left;
id	iets

(textString, i_size)

Table Row (tr)

id	des

Table Cell (td)
Returns a string with the requested number of characters, starting from the left.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} textString – the text to process {Object} i_size – the size of the text to return

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the result text string

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringLeftWords
class	node

Table Row (tr)

id	name

Table Cell (td)
stringLeftWords

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringLeftWords

Span

style	float: left;
id	iets

(text, numberof_words)

Table Row (tr)

id	des

Table Cell (td)
Returns the number of words, starting from the left.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} text – to process {Object} numberof_words – to return

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the string with number of words form the left

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringMD5HashBase16
class	node

Table Row (tr)

id	name

Table Cell (td)
stringMD5HashBase16

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringMD5HashBase16

Span

style	float: left;
id	iets

(textString)

Table Row (tr)

id	des

Table Cell (td)

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

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} textString – the text to process

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the resulting hashString

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var hashed_password = utils.stringMD5HashBase16(user_password)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringMD5HashBase64
class	node

Table Row (tr)

id	name

Table Cell (td)
stringMD5HashBase64

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringMD5HashBase64

Span

style	float: left;
id	iets

(textString)

Table Row (tr)

id	des

Table Cell (td)

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

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} textString – the text to process

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the resulting hashString

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var hashed_password = utils.stringMD5HashBase64(user_password)

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringMiddle
class	node

Table Row (tr)

id	name

Table Cell (td)
stringMiddle

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringMiddle

Span

style	float: left;
id	iets

(textString, i_start, i_size)

Table Row (tr)

id	des

Table Cell (td)
Returns a substring from the original string.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {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

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the result text string

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringMiddleWords
class	node

Table Row (tr)

id	name

Table Cell (td)
stringMiddleWords

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringMiddleWords

Span

style	float: left;
id	iets

(text, i_start, numberof_words)

Table Row (tr)

id	des

Table Cell (td)
Returns a substring from the original string.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} text – to process {Object} i_start – start word index {Object} numberof_words – the word count to return

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the string with number of words form the left and

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringPatternCount
class	node

Table Row (tr)

id	name

Table Cell (td)
stringPatternCount

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Number

Span

style	float: left; font-weight: bold;
id	iets

stringPatternCount

Span

style	float: left;
id	iets

(textString, searchString)

Table Row (tr)

id	des

Table Cell (td)
Returns the number of times searchString appears in textString.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} textString – the text to process {Object} searchString – the string to search

Table Row (tr)

id	ret

Table Cell (td)
Returns Number – the occurrenceCount that the search string is found in the text

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringPosition
class	node

Table Row (tr)

id	name

Table Cell (td)
stringPosition

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Number

Span

style	float: left; font-weight: bold;
id	iets

stringPosition

Span

style	float: left;
id	iets

(textString, searchString, i_start, i_occurrence)

Table Row (tr)

id	des

Table Cell (td)
Returns the position of the string to seach for, from a certain start position and occurrence.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {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

Table Row (tr)

id	ret

Table Cell (td)
Returns Number – the position

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringReplace
class	node

Table Row (tr)

id	name

Table Cell (td)
stringReplace

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringReplace

Span

style	float: left;
id	iets

(text, search_text, replacement_text)

Table Row (tr)

id	des

Table Cell (td)
Replaces a portion of a string with replacement text.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} text – the text to process {Object} search_text – the string to search {Object} replacement_text – the replacement text

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the changed text string

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringReplaceTags
class	node

Table Row (tr)

id	name

Table Cell (td)
stringReplaceTags

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringReplaceTags

Span

style	float: left;
id	iets

(text, foundset_or_record_or_form)

Table Row (tr)

id	des

Table Cell (td)
Returns the text with %%tags%% replaced, based on provided record or foundset or form.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} text – the text tags to work with {Object} foundset_or_record_or_form – the foundset or record or form to be used to fill in the tags

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the text with replaced tags

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//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);
//Next line places a string in variable y, whereby the tag(%%TAG%%) is filled with the value of the form variable 'x' of the form named 'main'.
var y = utils.stringReplaceTags("The value of form variable is %%x%% ", forms.main);

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringRight
class	node

Table Row (tr)

id	name

Table Cell (td)
stringRight

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringRight

Span

style	float: left;
id	iets

(textString, i_size)

Table Row (tr)

id	des

Table Cell (td)
Returns a string with the requested number of characters, starting from the right.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} textString – the text to process {Object} i_size – the size of the text to return

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the result text string

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringRightWords
class	node

Table Row (tr)

id	name

Table Cell (td)
stringRightWords

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringRightWords

Span

style	float: left;
id	iets

(text, numberof_words)

Table Row (tr)

id	des

Table Cell (td)
Returns the number of words, starting from the right.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} text – to process {Object} numberof_words – to return

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the string with number of words form the right

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringToNumber
class	node

Table Row (tr)

id	name

Table Cell (td)
stringToNumber

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Number

Span

style	float: left; font-weight: bold;
id	iets

stringToNumber

Span

style	float: left;
id	iets

(textString)

Table Row (tr)

id	des

Table Cell (td)
Filters characters out of from a string and leaves digits, returns the number.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} textString – the text to process

Table Row (tr)

id	ret

Table Cell (td)
Returns Number – the resulting number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringTrim
class	node

Table Row (tr)

id	name

Table Cell (td)
stringTrim

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

stringTrim

Span

style	float: left;
id	iets

(textString)

Table Row (tr)

id	des

Table Cell (td)
Returns the string without leading or trailing spaces.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} textString – the text to process

Table Row (tr)

id	ret

Table Cell (td)
Returns String – the resulting trimmed string

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

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

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	stringWordCount
class	node

Table Row (tr)

id	name

Table Cell (td)
stringWordCount

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Number

Span

style	float: left; font-weight: bold;
id	iets

stringWordCount

Span

style	float: left;
id	iets

(textString)

Table Row (tr)

id	des

Table Cell (td)
Returns the number of words in the text string.

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} textString – the text to process

Table Row (tr)

id	ret

Table Cell (td)
Returns Number – the word count

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//returns '4' as result
var retval = utils.stringWordCount('this is a test');

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	timestampToDate
class	node

Table Row (tr)

id	name

Table Cell (td)
timestampToDate

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Date

Span

style	float: left; font-weight: bold;
id	iets

timestampToDate

Span

style	float: left;
id	iets

(date)

Table Row (tr)

id	des

Table Cell (td)
Returns a datestamp from the timestamp (sets hours,minutes,seconds and milliseconds to 0).

Table Row (tr)

id	prs

Table Cell (td)
Parameters {Object} date – object to be stripped from its time elements

Table Row (tr)

id	ret

Table Cell (td)
Returns Date – the stripped date object

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var date = utils.timestampToDate(application.getTimeStamp());

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 15

New Version Current

Key

dateFormat

getUnicodeCharacter

hasRecords

isMondayFirstDayOfWeek

numberFormat

stringEscapeMarkup

stringFormat

stringIndexReplace

stringInitCap

stringLeft

stringLeftWords

stringMD5HashBase16

stringMD5HashBase64

stringMiddle

stringMiddleWords

stringPatternCount

stringPosition

stringReplace

stringReplaceTags

stringRight

stringRightWords

stringToNumber

stringTrim

stringWordCount

timestampToDate