Table of contents
TOC
Collapse the table of content
Expand the table of content

Text.Format

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

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. Optionally, a culture may be specified.

Example 1

Format a list of numbers.

Text.Format("#{0}, #{1}, and #{2}.", { 17, 7, 22 })  
Equals: "17, 7, and 22."  

Example 2

Format different data types from a record according to United States English culture.

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")  
Equals: "The time for the 10 km run held in Seattle on 3/10/2015 was 00:54:40."  
© 2018 Microsoft