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

ItemTemplate edit

Summary SpreadSheetPlugin functions SUBSTITUTE and REPLACE cannot return number 0 or empty string
ReportedBy TWiki:Main.DiabJerius
Codebase trunk
SVN Range TWiki-4.3.0, Fri, 12 Oct 2007, build 15261
AppliesTo Extension
Component SpreadSheetPlugin
Priority Normal
CurrentState Closed
WaitingFor
Checkins distro:ebd76bcd8bae
TargetRelease patch
ReleasedIn 1.0.0
Topic revision: r4 - 08 Jan 2009, KwangErnLiew
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy