Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bobbydave
Contributor III

Filename extension

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?

1 Solution

Accepted Solutions

Re: Filename extension

May be this:

LOAD

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

or

LOAD

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

View solution in original post

3 Replies

Re: Filename extension

May be this:

LOAD

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

or

LOAD

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

View solution in original post

bobbydave
Contributor III

Re: Filename extension

Wow .... as simple as that.

Thanks

Re: Filename extension

Absolutely