Composite Text Attributes Formats
Format | Summary | Example |
---|---|---|
{0} | Returns the value as it is. | {0} ~ 0:A65 = A65 |
:C | Returns the numeric value as currency. | {0:C} ~ 0:55674.74 = $55,674.74 |
:E | Returns the numeric value as scientific notation. | {0:E} ~ 0:123456789 = 1.234568E+008 |
:F | Returns the numeric value with a fixed number of decimals. | {0:F1} ~ 3.14159 = 3.1 |
:000.000 | Returns the numeric value with zero placeholders. | {0:0000} ~ 0:12.34 = 0012 |
:##.## | Retruns a numeric value where the # symbol is replaced with the corresponding digit if one is present; otherwise, no digit appears in the result. | {0:####} ~ 0:1234.5678 = 1235 |
:% | Returns the numeric value multiplied by 100 and with a percentage symbol. | {0:%} ~ 0:0.002 = 0.2% |
:‰ | Returns the numeric value mupliplied by 1000 and with a per mile symbol. | {0:‰} ~ 0:0.002 = 2‰ |
:d | Returns the short date representation of a date and time. | {0:d} ~ 0:4/18/2008 6:30:15 AM = 4/8/2008 |
:D | Returns the long date representation of a date and time. | {0:D} ~ 0:4/18/2008 6:30:15 AM = Friday, April 18, 2008 |
:t | Returns the short time representation of a date and time. | {0:t} ~ 0:4/18/2008 6:30:15 AM = 6:30 AM |
:T | Returns the long time representation of a date and time. | {0:T} ~ 0:4/18/2008 6:30:15 AM = 6:30:15 AM |
:F | Returns the long date and time representation of a date and time. | {0:F} ~ 0:4/18/2008 6:30:15 AM = Friday, April 18, 2008 6:30:15 AM |
:f | Returns the long date and short time representation of a date and time. | {0:f} ~ 0:4/18/2008 6:30:15 AM = Friday, April 18, 2008 6:30 AM |
:G | Returns the general date and time representation of a date and time. | {0:G} ~ 0:4/18/2008 6:30:15 AM = 4/18/2008 6:30:15 AM |
:g | Returns the general date and short time representation of a date and time. | {0:g} ~ 0:4/18/2008 6:30:15 AM = 4/18/2008 6:30 AM |
:M | Returns the month and day representation of a date and time. | {0:M} ~ 0:4/18/2008 6:30:15 AM = April 18 |
:Y | Returns the year and month representation of a date and time. | {0:Y} ~ 0:4/18/2008 6:30:15 AM = April 2008 |
:s | Returns the sortable date and time representation of a date and time. | {0:s} ~ 0:4/18/2008 6:30:15 AM = 2008-04-18T06:30:15 |
:U | Returns the universal date and time representation of a date and time. | {0:U} ~ 0:4/18/2008 6:30:15 AM = Friday, April 18, 2008 10:30:15 AM |
:u | Returns the universal, sortable date and time representation of a date and time. | {0:U} ~ 0:4/18/2008 6:30:15 AM = 2008-04-18 06:30:15z |
:dd/MM/yyyy HH-mm-ss | Returns the day, month, year, hour, minute and second representation of a data and time. These components can be modified freely. | {0:MM/dd/yyyy} ~ 0:4/18/2008 6:30:15 AM = 04/18/2008 |
:choose | Searches for a value in a list of options and outputs the corresponding value from a list of outputs. | {0: choose (1|2|3):one|two|three|other} ~ 0:2 = two |
:cond:<choices> | The value of the number determines the position in the list of choices. Values outside the range of choices will output the default. | {0:cond:First|Second|Default} |
:cond:<logic> | The value is tested against a range of logical comparisons with separate outputs. Comparisons can be combined using ‘&' for AND or '/’ for OR. | {0:cond:<=0?Unborn?|>=55?Senior|>=18?Adult|>12?Teenager|>?Child|Baby} ~ 0:35 = Adult |
:cond:{} | The value is checked if it is empty. If the value is empty, a placeholder value is returned: otherwise, the value is returned as it is. | {0:cond: { } | Empty} ~ 0: = Empty |
.ToLower | Returns the text in lower case. | {0.ToLower} ~ 0:Room = room |
.ToUpper | Retruns the text in upper case. | {0.ToUpper} ~ 0:Room = ROOM |
:substr | Returns a slice of the provided text. The slice is decided by a start position and optional end positions, starting from 0. | {0:substr (7) } ~ 0:Doctor Rofus = Rofus |