The FileExtension function returns a string containing the extension of the table file currently being read.
Syntax:
FileExtension()
LOAD *, FileExtension( ) as X from
C:\UserFiles\abc.txt