The SVN Range in ItemTemplate should not include the date, only the build number. The formula

* Set REV = %CALC{"$SUBSTITUTE(%WIKIVERSION%,.*Rev:,,,r)"}% 

Worked differently on TWiki.org than on Develop:

• On TO it is "build number $"
  • http://twiki.org/cgi-bin/view/Plugins/SpreadSheetPlugin?formula=%24SUBSTITUTE%28%25WIKIVERSION%25%2C.*Rev%3A%2C%2C%2Cr%29
• On DTO it resolves to "day name"
  • See GetRev

I wanted also to be rid of the $, but the following failed on TO:

• http://twiki.org/cgi-bin/view/Plugins/SpreadSheetPlugin?formula=%24SUBSTITUTE%28%25WIKIVERSION%25%2C.*Rev%3A%28.*%29%24%2C%241%2C%2Cr%29
• http://twiki.org/cgi-bin/view/Plugins/SpreadSheetPlugin?formula=%24SUBSTITUTE%28%25WIKIVERSION%25%2C.*Rev%3A%28.*%29%24%2C%5C1%2C%2Cr%29

Any help appreciated.

-- MC

Could it be because %WIKIVERSION% (TWiki-6.1.0-trunk, Mon, 15 May 2023, build 31065) contains a comma?

CC

Ugh. Is there a quoting solution to this? That's horrid.

MC

Quting is currently not supported. Workaround: Translate the comma into an unused temp char, do the substitution, translate back: $TRANSLATE($SUBSTITUTE($TRANSLATE)))

-- PTh

Thanks but am discarding as I can't get my brain around this and am unwilling to waste any more time on GetRev.

-- MC

Undeferred, post Dakar

CC

Quoting text to escape comma is not supported at this time.

-- PTh