community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

text to columns converts \n to newline

Alteryx Partner

I'm using text to columns with a comma delimiter.  I've noticed that a side effect of this is to change the 2 character "\n" combination to a single ascii newline character.  

 

I've nothing set in the advanced options.  Is there a way to control this behaviour?

Moderator
Moderator

Hi @Rowan,

 

Could you please provide a screenshot of the issue?

 

I have tried to recreate it based on your description but results are as expected:

 

Spoiler
Tool configuration:

TextToColumn presentation.png

Results:

Results.png

Kind regards,

 

Paul Noirel

Customer Support Engineer

 

Alteryx Partner

I've created a workflow to repro this.  

 

When I did the repro I discovered it's an earlier JSON parse that is the origin of the translation.  not the text to columns as I mentioned

Moderator
Moderator

Hi @Rowan,

 

I need to check the reasons of this behaviour. In the same time, you could use the workaround described on https://community.alteryx.com/t5/Data-Preparation-Blending/Replacing-escaping-special-characters-to-....

 

Kind regards,

 

Paul Noirel

Customer Support Engineer

Alteryx Partner

Yes if I escape the field (changing "\n" to "\\n") I can work around the issue.  

Labels