Item9343: Variation on TRIM to remove all spaces

Priority:	CurrentState:	AppliesTo:	Component:	WaitingFor:
Enhancement	New	Extension	SpreadSheetPlugin

TRIM reduces multiple spaces to one space. But there needs to be a variant that removes all spaces, e.g. to turn "Hello, world" into "HelloWorld".

I'm looking for the reverse of PROPERSPACE.

This works:

%CALC{$TRANSLATE($SUBSTITUTE($TRANSLATE(a string with comma, and spaces, $sp$comma, $CHAR(29)$CHAR(30)), $CHAR(29)), $CHAR(30), $comma)}%

but oh my that's too complex!

-- VickiBrown - 16 Jul 2010

There appears to be some capitalisation going on, too. This is an enhancement and requires a FeatureRequest. Please link back to this task when one exists.

-- CrawfordCurrie - 08 Sep 2010

Request filed: TrimAllSpaces

-- VickiBrown - 11 Sep 2010