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

Value.FromText

Owen Duncan|Last Updated: 4/19/2018

About

Decodes a value from a textual representation, value, and interprets it as a value with an appropriate type. Value.FromText takes a text value and returns a number, a logical value, a null value, a DateTime value, a Duration value, or a text value. The empty text value is interpreted as a null value.

Value.FromText(value as text, optional culture as nullable text)  

Arguments

ArgumentDescription
valueThe value to transform.
optional cultureA text value corresponding to the culture values supported on your version of Windows, such as "en-US". If the culture is not specified, the current user culture is used. For a list of culture names, see National Language Support (NLS) API Reference.

Examples

Value.FromText("1") equals 1  
Value.FromText("2012/5/16") equals #date(2012,5,16)  
Value.FromText("null") equals null  
Value.FromText("somevalue") equals "somevalue"  
© 2018 Microsoft