Skip to main content
Skip table of contents

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
{0:F3} ~ 3.14159 = 3.142

:000.000

Returns the numeric value with zero placeholders.

{0:0000} ~ 0:12.34 = 0012
{0:0000.0000} ~ 0:12.34 = 0012.3400

:##.##

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
{0:(#).##} ~ 0:12.34 = (12).34

:%

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
{0:HH-mm-ss} ~ 0:4/18/2008 6:30:15 AM = 06-30-15
{0:dddd, dd MMMM yyyy h-mm tt} ~ 0:4/18/2008 6:30:15 AM = Friday, 18 April 2008 6-30 AM

: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
{0: choose (True|False):Yes|No} ~ 0:True = Yes
{0: choose (1.224|B.356):Finished|Unfinished|Unknown} ~ 0:B.356 = Unfinished

: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}
{0:cond:Apple|Oragne|Banana|No fruit} ~ 0:2 = Banana
{0:cond:Yesterday|Today|Tomorrow} ~ 0:6/8/2023 5:15:56 PM = Today

: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
{0:cond: { } | Empty} ~ 0:A21 = A21

.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
{0:substr (0,6) } ~ 0:Doctor Rofus = Doctor
{0:substr (7) : {ToUpper} } ~ 0:Doctor Rofus = ROFUS

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.