DETERMINE_TYPE Function

Returns the type of data that the input string represents.

Category: Date
Returned data type: String

Syntax

determine_type

Arguments

string

is the string of data

returns

the data type the input string represents.

Details

This function analyzes a string to determine whether it is one of the following options: string, integer, Boolean, date, or real.

Examples

Example 1

1000

Results: integer

Example 2

1000.5

Results: real