The SUBSTITUTE function doesn't return the correct result when
text =
old and
replace is empty.
For example, I expect the following to produce an empty result:
%CALC{"$SUBSTITUTE(Public,Public)"}%
Instead it produces the string
Public
Note that
%CALC{"$SUBSTITUTE(Public,Public,Foo)"}%
produces
Foo
--
TWiki:Main/DiabJerius - 16 Oct 2007
yes this has also annoyed me
And there is similar problem with REPLACE which cannot return a number 0 or an empty string either even though there can be good use for both in applications.
Fixing.
--
KennethLavrsen - 06 Jan 2009