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.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!