Discussion board where members can get started with QlikView.
So I have a filename with the
Filenames would be like
Because the Service names vary in the number of characters, how do I get just the Service?
Go to Solution.
May be this:
SubField(FileBaseName(), '_', -1) as Service
Replace(SubField(FileName(), '_', -1), '.xlsx', '') as Service
View solution in original post
Wow .... as simple as that.