The FileBaseName function returns a string containing the name of the table file currently being read, without path or extension.
Syntax:
FileBaseName()
Examples and results:
| Example | Result |
|---|---|
|
LOAD *, filebasename( ) as X from C:\UserFiles\abc.txt |
Will return 'abc' in field X in each record read. |
