Discussion Board for collaboration on QlikView Scripting.
Hello there folks,
I am trying to figure something out here, I would like to remove all descriptions from a field which starts with the character '.' and '-'.
I have tried the below script but failed badly, could anyone point me in the right direction or advise on what am doing wrong here.
where [BrandDesc] <> '.*' and [BrandDesc] <> '-*';
Thanks in advance.
Go to Solution.
Use WildMatch() function. Like:
where Not WildMatch([BrandDesc], '.*' , '-*' );
Are you load data from QVD? If yes, then try
Where not WildMatch([BrandDesc],'.*','-*');
Thanks! Spot on.
If you only want to remove these description but keep the rest of the fields for each record of the table I suggest using the following:
If(not( Left([BrandDesc],1)='.') or not( Left([BrandDesc],1)='-'), [BrandDesc] ,null()) as [BrandDesc]