Carriage Returns in Data - Creating New Rows

[MonBrazier]

Please help! Hopefully this is an easy one!

I have a tab delimited csv file that contains carriage returns within a particular field.

Unfortunately this comes through a new row within Alteryx.

Does anyone know how I can handle this situation so there is no new row within Alteryx?

Thanks!

[MonBrazier]

Thanks everyone 🙂

I thought I might share the solution.

It was an adaptation of your brilliant suggestions - thank you very much.

The only additional mechanism I needed to add in was a way to dynamically set the number of columns to split by (so that all files we receive can have carriage returns removed).

Here is an excellent link here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Parsing-Data-with-Unknown-Number-of...

This helped determine how to do that.

Thanks again everyone. 🙂

Cheers,

Mon