Finding out the file extension

[#1]

Hi All,

Is it possible to find out the file extension of a file in the script?

Thanks,

Asma

[#2]

yes.

Use

Subfield(filename(),'.',2) as FileExtension

to get file extension.

example:

tab1:

Load Subfield(filename(),'.',2) as FileExtension,*

FROM excel or database

Regards,

Uday.

[tresB · Accepted solution]

Like this:

Load *, fileextension( ) as Ext

from .....\abc.txt