Value.FromText

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.

Syntax

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

Arguments

Argument Description
value The value to transform.
optional culture A 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"