# File functions

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)The file functions (only available in script expressions) return information about the table file which is currently being read. These functions will return NULL for all data sources except table files (exception: ConnectString( )).

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### Attribute

This script function returns the value of the meta tags of different media files as text. The following file formats are supported: MP3, WMA, WMV, PNG and JPG. If the file filename does not exist, is not a supported file format or does not contain a meta tag named attributename, NULL will be returned.

[**Attribute**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/Attribute.htm)(filename, attributename)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### ConnectString

The ConnectString() function returns the name of the active data connection for ODBC or OLE DB connections. The function returns an empty string if no connect statement has been executed, or after a disconnect statement.

[**ConnectString**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/ConnectString.htm)()

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### FileBaseName

The FileBaseName function returns a string containing the name of the table file currently being read, without path or extension.

[**FileBaseName**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/FileBaseName.htm)()

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### FileDir

The FileDir function returns a string containing the path to the directory of the table file currently being read.

[**FileDir**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/FileDir.htm)()

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### FileExtension

The FileExtension function returns a string containing the extension of the table file currently being read.

[**FileExtension**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/FileExtension.htm)()

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### FileName

The FileName function returns a string containing the name of the table file currently being read, without path but including the extension.

[**FileName**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/FileName.htm)()

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### FilePath

The FilePath function returns a string containing the full path to the table file currently being read.

[**FilePath**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/FilePath.htm)()

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### FileSize

The FileSize function returns an integer containing the size in bytes of the file filename or, if no filename is specified, of the table file currently being read.

[**FileSize**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/FileSize.htm)()

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### FileTime

The FileTime function returns a timestamp in UTC for the date and time of the last modification of the file filename. If no filename is specified, the function will refer to the currently read table file.

[**FileTime**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/FileTime.htm)([ filename ])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### GetFolderPath

The GetFolderPath function returns the value of the Microsoft Windows SHGetFolderPath function. This function takes as input the name of a Microsoft Windows folder and returns the full path of the folder.

[**GetFolderPath**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/GetFolderPath.htm)()

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### QvdCreateTime

This script function returns the XML-header timestamp from a QVD file, if any is present, otherwise it returns NULL. In the timestamp, time is provided in UTC.

[**QvdCreateTime**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/QvdCreateTime.htm)(filename)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### QvdFieldName

This script function returns the name of field number fieldno, if it exists in a QVD file (otherwise NULL).

[**QvdFieldName**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/QvdFieldName.htm)(filename , fieldno)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### QvdNoOfFields

This script function returns the number of fields in a QVD file.

[**QvdNoOfFields**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/QvdNoOfFields.htm)(filename)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### QvdNoOfRecords

This script function returns the number of records currently in a QVD file.

[**QvdNoOfRecords**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/QvdNoOfRecords.htm)(filename)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/file-functions-script.htm)

#### QvdTableName

This script function returns the name of the table stored in a QVD file.

[**QvdTableName**](https://help.qlik.com/en-US/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/QvdTableName.htm)(filename)