File Functions
A file function builds file paths, checks to see if a file exists, or extracts a part of a file path. You can only use File functions with String data types.
FileAddPaths
FileAddPaths(Path1, Path2)
: Adds 2 file path parts, making sure there is exactly 1 \ (backslash) between the 2 paths.
Example
FileAddPaths([C:\Temp], [Data\file.csv])
returns C:\Temp\Data\file.csv
.
FileExists
FileExists(Path)
: Returns True
if the file exists and False
if it doesn't.
Example
FileExists(C:\Temp)
returns "True".
FileExists(C:\Temp\Data\file.csv)
returns "True".
FileExists(C:\Temp\Data\NoFile.csv)
returns "False".
FileGetDir
FileGetDir(Path)
: Returns the directory portion of the path.
Example
FileGetDir(C:\Temp\Data\file.csv)
returns C:\Temp\Data
.
FileGetDir(C:\Temp\Data)
returns C:\Temp
.
FileGetExt
FileGetExt(Path)
: Returns the extension of the path, including the "." (period).
Example
FileGetExt(C:\Temp\Data\file.csv)
returns ".csv".
FileGetExt(C:\Temp\Data)
returns " ".
FileGetFileName
FileGetFileName(Path)
: Returns the name portion of the path, without the extension.
Example
FileGetName(C:\Temp\Data\file.csv)
returns "file".
FileGetName(C:\Temp\Data)
returns "Data".