Convert Embedded Lines into Single Lines and eliminate truncated characters

[OmaratRJL]

I have a web based csv file that contains two essential fields somewhere in the second field there is an embedded carriage return(enter)  and hidden characters. If I physically download the file there are no issues but if i open it up through Alteryx there is an error. So what exactly is happening here and what can I do to resolve it?

[LordNeilLord · Accepted solution]

Hey @OmaratRJL

You can use the download tool to place the csv in a tmp file and then use the dynamic input tool to open the CSV...this will solve the issue you are having.