Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator 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
sunny_talwar

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
sunny_talwar

May be this:

LOAD

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

or

LOAD

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

View solution in original post

bobbydave
Creator III
Creator III
Author

Wow .... as simple as that.

Thanks

sunny_talwar

Absolutely