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

Commenting is disabled while not logged in