cross
If you cannot get logged in, clear your cookies for foswiki.org and retry. The Foswiki Cookie Domain has been changed.
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 - This page was cached on 25 Jan 2017 - 02:54.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License