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 distro:ebd76bcd8bae
TargetRelease patch
ReleasedIn 1.0.0
Topic revision: r4 - 08 Jan 2009, KwangErnLiew - This page was cached on 04 Oct 2015 - 15:25. Get a fresh version here.
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License