How to remove the New line / Line break Character
Looking for a solution to remove the line break or new line character from the text formatted line item editable by end users.
reading the text from the user editable line item to another line item, in the process want to replace new line character if any from the text. Because of New Line character the data while being exported and loaded into the target system resulting into loss of data.
Answers
-
Hmmm. I've seen this before. Did you try using the TRIM function?
https://help.anaplan.com/en/068058a3-7495-427b-bfb1-d8b9f8d0e62d-TRIM
You can't prevent users from entering the Line Feed but you can create another line item that will remove it.
1 -
Thanks! We had the same problem and TRIM worked!
0 -
True, TRIM function has removed the above challenge and eliminated data loss problem
0