Plain Text Type or CLEANTEXT function

CommunityMember127794

Anaplan allows users to paste text from dirty sources like Word which includes nasty characters like CR/LR, smart quotes, em/en dashes, etc. These invariably cause problems when exporting data from Anaplan.

I suggest adding a fourth Text Type to the Text format.

Plain Text would convert entered/pasted text to plain text and str ip out CR/LF/white space like TRIM. This would prevent garbage characters from getting introduced into the model to begin with.

Alternatively, addition of a CLEANTEXT function that would perform the same function or could omit the TRIM portion.