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

Get(OpenDataFileInfo)

Returns the file ID and path of each open data file.

Format 

Get ( OpenDataFileInfo )

Parameters 

None

Data type returned 

text

Originated in version 

18.0

Description 

Information about each open data file is separated by a line break. Each line follows this format:

<file ID><tab><path><line break>

File IDs are returned by the Open Data File script step when a file is opened. Paths are named according to FileMaker Pro conventions (see Creating file paths).

Example 1 

When two data files are open, this function may return the following:

Windows:

1 file:/C:/Users/user_name/Documents/change.log
2 file:/C:/Users/user_name/Desktop/sap001.txt

macOS:

15 file:/Macintosh HD/Users/user_name/Documents/change.log
16 file:/Macintosh HD/Users/user_name/Desktop/sap001.txt

Example 2 

Returns the number of open data files.

ValueCount ( Get ( OpenDataFileInfo ) )

Example 3 

Returns the number of open data files that are in the Documents folder.

PatternCount ( Get( OpenDataFileInfo ) ; Get ( DocumentsPath ) )

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions