4 Replies Latest reply: Jun 12, 2018 3:04 AM by Jeroen Lansbergen RSS

    iAuditor vs Qlik sense; remove characters left & right

    Jeroen Lansbergen

      Ls,

       

      When using a csv file extracted from iAuditor I get to many characters as input in my field

      Example:

      Field name Action_Priority gives an output ""Medium"" where I want to remove the "" on both sides. Basically this counts for all Fields.

       

      I have tried:

      Action_Priority,

          Left(Action_Priority, Len(Action_Priority)-2) as Action_Priority2,

       

      This works for one side (characters "" on the right are removed but I don't manage it to get it also working on the left.

       

      Any ideas?

       

      On the other hand it would be great if there is also a single line scripting removing the characters "" text "" for all fields.

      I am not a Qlik sense Goeroe so please be patience

       

      Thanks in advance !!