Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Syntax
Text.Format(formatString as text, arguments as any, optional culture as nullable text) as text
About
Returns formatted text that is created by applying arguments
from a list or record to a format string formatString
. An optional culture
may also be provided (for example, "en-US").
Example 1
Format a list of numbers.
Usage
Text.Format("#{0}, #{1}, and #{2}.", {17, 7, 22})
Output
"17, 7, and 22."
Example 2
Format different data types from a record according to United States English culture.
Usage
Text.Format(
"The time for the #[distance] km run held in #[city] on #[date] was #[duration].",
[
city = "Seattle",
date = #date(2015, 3, 10),
duration = #duration(0, 0, 54, 40),
distance = 10
],
"en-US"
)
Output
"The time for the 10 km run held in Seattle on 3/10/2015 was 00:54:40."