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!

Datasets

Input

Accepted answers

AbhilashR

Hi @MonBrazier, my suggestion would be to bring in the CSV data into Alteryx as is, parse the data and then remove the unwanted carriages. Something like the attached sample solution.

I have had success using this approach in the past and am hoping it works out for you too.

sample.yxzp

MarqueeCrew

Aaaah!

use \0 as your delimiter when you read! also, uncheck first row option to keep names as data.

Next use one of my replace expressions.

now use a text to columns to create the right number of fields.

now a dynamic rename and change the drop down option to use first row as names.

the issue is that the row update happens on the input tool.

cheers,

mark

All comments

MarqueeCrew

Try this:

regex_replace([fieldname],"\n","")

that will delete the newline

Cheers,

Mark

ps: \r is a carriage return if \n doesn't work.

MonBrazier

Thanks for the suggestion.

Unfortunately this didn't work.

The carriage return comes through as a new row on initial input:

MarqueeCrew

Let's use brute force:

regex_replace([field],"[^ -~]","")

cheers

mark

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703