It would be great if Alteryx could better handle Carriage Returns! If I have a csv file that has Carriage Returns (\r) in the Description field Alteryx displays it like so in the browse tool:
![1.png 1.png](https://community.alteryx.com/t5/image/serverpage/image-id/13347iF85CEA665493C427/image-size/large?v=v2&px=999)
I’m ok that it’s ignoring the carriage returns entirely to better display the data, but the problem is that there is no way to know by looking at this browse tool that there are “hidden” carriage returns in my data. When we try to copy this to excel and it looks like this:
Unfortunately, this isn’t quite how I was expecting it to look. I think there are three related changes I would like to see:
1) Change the copy feature of the browse tool so that it ignores carriage returns (\r) just like when you display it in a browse tool.
2) Make a new character that would display the carriage return when I click the “show whitespaces” button. It shows line feeds (\n) as paragraph symbols but won’t show carriage returns (\r). Here is what the \n looks like if I replace my \r with \n:
![3.png 3.png](https://community.alteryx.com/t5/image/serverpage/image-id/13349iF699A99AB363848B/image-size/large?v=v2&px=999)
My \r character currently doesn’t display at all:
![4.png 4.png](https://community.alteryx.com/t5/image/serverpage/image-id/13350iD25431450A82C1A7/image-size/large?v=v2&px=999)
3) Add the red triangle indicator similar to the line feed (\n):
![5.png 5.png](https://community.alteryx.com/t5/image/serverpage/image-id/13351i301446EC8B16B206/image-size/large?v=v2&px=999)
I currently get no warning that there are embedded carriage returns.
Thanks!