The foswiki svn repository will become read-only on Friday 8/8. Developers should register for a account for commit access to foswiki.
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:
Instead it produces the string
Note that

-- 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.


-- 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
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