FileBaseName - script function

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.