All formatters:
The list of all available formatter
Format field:
This label show:
- the name of the recordset
- the name of the field
- the name of the selected HTML element
Formatters:
The list of formatter applyed to the field
Average:
Return the average of the selected recordset field.
Count:
Return the number of records in the recordset
Join:
Returns the values of a recordset field joined together with the given character.
Last:
Return the given number of records from the end of the recordset
Max:
Return the max value of the selected recordset field
Min:
Return the min value of the selected recordset field
Sum:
Return the sum value of the selected recordset field
Top:
Return the given number of records from the beginning of the recordset
Sort:
Sort the recordset for the selected field
Where:
Filter the recordset for the selected field value
Between:
Filter the recordset and return only the records where the selected field value is between the 2 value you enter
Contains:
Filter the recordset and return only the records where the selected field value contains the text you enter
EndWith:
Filter the recordset and return only the records where the selected field value end with the text you enter
StartWidth:
Filter the recordset and return only the records where the selected field value start with the text you enter
Test:
Filter the recordset and return only the records where the selected field value match with the regular expression you enter:
Camelcase:
Camelcase the string value, For example "DwZone Binding Formatter" is formatted to "dwzone Binding Formatter "
Camelize:
Camelize the string value, For example "dwzone binding formatter" is formatted to "Dwzone Binding Formatter"
Capitalize:
Capitalize the string value, For example "DwZone Binding Formatter" is formatted to "Dwzone binding formatter"
Dasherize:
Dasherize the string value, For example "DwZone Binding Formatter" is formatted to "DwZone-Binding-Formatter"
Humanize:
Humanize the string value, For example "DwzoneBindingFormatter" is formatted to " Dwzone Binding Formatter"
LowerCase:
Convert the value to all lower-case characters
UpperCase:
Convert the value to all upper-case characters
Replace:
Replace the given string in the text value
Slugify:
Slugify the string value, For example "Dwzone Binding Formatter" is formatted to "dwzone-binding-formatter"
TrimStart:
Remove the given character from the beginning of the text, if no characters is entered remove the spaces
Trim:
Remove the given character from the beginning and from the end of the text, if no characters is entered remove the spaces
TrimEnd:
Remove the given character from the end of the text, if no characters is entered remove the spaces
Left:
Return the given number of characters from the beginning of the text
Right:
Return the given number of characters from the end of the text
Substring:
Return the given number of characters from the entered position of the text
HtmlEntities:
Convert all applicable characters to HTML entities
HtmlSpecialChars:
Convert special characters to HTML entities
Bin2Hex:
Convert binary data into hexadecimal representation
Hex2Bin:
Decodes a hexadecimally encoded binary string
MD5:
Calculate the md5 hash of a string
SHA1:
Calculate the sha1 hash of a string
Nl2Br:
Replace the NewLine characters with HTML BR tag
StripTags:
Strip ASP tags from a string
StrLen:
Retutn the length of the text
StrRev:
Reverse the string
Abs:
Return the absolute value
Ceil:
Round fractions up
FormatNumber:
Format a number
Floor:
Round fractions down
PadNumber:
Convert a number to a string and pad to the given length with leading zero
Round:
Rounds a float with the given number of decimals
DecBin:
Convert decimal number to the binary value
BinDec:
Convert binary value to the decimal number
DecHex:
Convert decimal number to the hexadecimal value
HexDec:
Convert hexadecimal value to the decimal number
DecOct:
Convert decimal number to the octal value
OctDec:
Convert octal value to the decimal number
Deg2Rad:
Converts the number in degrees to the radian equivalent
Rad2Deg:
Converts the radian number to the equivalent number in degrees
DateAdd:
Adds an amount of days, months, years, hours, minutes and seconds to a DateTime object
DateDiff:
Returns the difference between two DateTime objects
DaysInMonth:
Return the number of days in a month for a given year and calendar
DateFormat:
Format a date with the given pattern. You can write your own pattern
