This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
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?
Could you please provide a screenshot of the issue?
I have tried to recreate it based on your description but results are as expected:
Customer Support Engineer
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
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-....
Yes if I escape the field (changing "\n" to "\\n") I can work around the issue.