Filename extension

[bobbydave]

So I have a filename with the

Date_Area_Service.xlsx

Filenames would be like

032016_BR_Telecoms.xlsx

042015_BR_Networks.xlsx

052016_BR_ADS.xlsx

062015_BR_ServiceDesk.xlsx

Because the Service names vary in the number of characters, how do I get just the Service?

[sunny_talwar · Accepted solution]

May be this:

LOAD

SubField(FileBaseName(), '_', -1) as Service

or

LOAD

Replace(SubField(FileName(), '_', -1), '.xlsx', '') as Service

[bobbydave]

Wow .... as simple as that.

Thanks

[sunny_talwar]

Absolutely