Better Handling of Carriage Returns

[patrick_digan]

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:

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:

My \r character currently doesn’t display at all:

3) Add the red triangle indicator similar to the line feed (\n):

 

I currently get no warning that there are embedded carriage returns.

Thanks!

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!