FileExtension - script function

The FileExtension function returns a string containing the extension of the table file currently being read.

Syntax:  

FileExtension()

 

Examples and results:

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