FileName - script function

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

Syntax:

FileName()

Example	Result
LOAD *, FileName( ) as X from C:\UserFiles\abc.txt	Will return 'abc.txt' in field X in each record read.

Example

Result

LOAD *, FileName( ) as X from

C:\UserFiles\abc.txt

Will return 'abc.txt' in field X in each record read.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!