search

RobWunderlich / Qlikview-Components

A library for common Qlikview Scripting tasks
197 stars 99 forks source link

Qvc.Icons do not get correct file name #57

Closed pljluca closed 7 years ago

pljluca commented 7 years ago

In Qvc.Icons on row 38: LET _qvctemp.currImgName = capitalize(subfield(subfield(_qvctemp.img, '\', -1), '.', 1));

the Capitalize function alter the file name. I tested the function Qvc.Icons by a file name My.Test.File.Name.png and in table as value I have only My.

To solve the problem I used LET _qvctemp.currImgName = Left(SubField(_qvctemp.img, '\', -1), Index(SubField(_qvctemp.img, '\', -1), '.', -1)-1);

or as I like, split on two expressions

LET _qvctemp.currImgName = SubField(_qvctemp.img, '\', -1);
LET _qvctemp.currImgName = Left(_qvctemp.currImgName, Index(_qvctemp.currImgName, '.', -1)-1);

Best regards Luca