This question about Using an extension: Answered
Seeking Help on SUBSTITUTE function in Spreadsheet Plugin
The SUBSTITUTE command is as folows
%CALC{" $SUBSTITUTE(theString, old_char,new_char) "}%
My old_char is a delimiter such as | (it can be any character) and I want to change it to a comma. For example,
"C&A|CABO|Documentation|Capabilities" is the string and I wish to change the | to commas as such:
C&A,CABO,Documentation,Capabilities
--
JoeMarandola - 14 Feb 2012
Instead of SUBSTITUTE, Try TRANSLATE
%CALC{$TRANSLATE("C&A|CABO|Documentation|Capabilities",|,$comma)}%
returns
"C&A,CABO,Documentation,Capabilities"
--
GeorgeClark - 15 Feb 2012
Note - Added $comma and $sp to the plugin for the next release -
Item11523
--
GeorgeClark - 15 Feb 2012
Thank you George. I tried using $comma in the substitute and when that didn't work tried all types of other methods. TRANSLATE works just fine.
--
JoeMarandola - 16 Feb 2012