Plain Text Type or CLEANTEXT function


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.

3 votes

New · Last Updated

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!