Item8237: Comma, newline and parenthesis supported using new tripple-quote syntax.

%CALC% seems to have a problem with values that have a "," inside. I often use %CALC{$IF(condition,var1,var2)}% to filter the output of a %SEARCH%. If the condition is false and var1 contains a "," then the part after the "," of var1 is printed. Thats a big mess for tabels, because the numbers of rows is usually to low (just half of the output). Most of the time I try to use the function in with an output only of condition is wrong and var1="". That works if I want to have a simple decision "ouput or no output", but it´s a problem for "output1 or output2".

So there should be a feature that I can prevent var1 to be literaly put into the $IF()-function, so the "," is not interpreted by this function.

This problem my be related to Item411

-- HolgerHain - 12 Aug 2009

Indeed it does. Confirmed.

-- CrawfordCurrie - 08 Sep 2010

Fixed in 1.2. Strings with comma, newline and parenthesis should be triple-quoted with single quotes.

-- GeorgeClark - 04 Jan 2015

Commenting is disabled while not logged in