Foswiki on GitHub is open for business! Next release meeting: Monday September 29, 1300Z
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 Foswikirev:1774
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 CopyrightStatement. Creative Commons License