Reference > Functions reference > Get functions > Get(FileName)
 

Get(FileName)

Returns the name of the currently active file, without the filename extension.

Format 

Get ( FileName )

Parameters 

None

Data type returned 

text

Originated in version 

6.0 or earlier

Description 

If the current calculation is stored and you specify its context, this function will be evaluated based on that context; otherwise, it will be evaluated based on the context of the current window.

Notes 

If you use Get(FileName) in a function parameter that requires a filename and the filename contains a period, include the filename extension in the parameter. Otherwise, functions may interpret the period in the filename as the beginning of the filename extension, which can lead to unexpected results.

Example 1 

Returns Contacts when Contacts is the active file.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas