How can I remove line breaks from a string column in an ETL?

adolven

I have a dataset that includes line breaks in some cells.

I was trying to use the "Replace Text" action, but I'm not sure how Domo is coding the breaks. '\n' and '<br>' did not work.

In Domo, you can't visually see the line breaks, but as soon as I download the CSV and open in Excel, I can see them (screen shot attached).

Any guidance on this would be greatly appreciated. Thank you!

Domo:

Excel:

GrantSmith

You can use a formula tile and the regexp_replace function:

REGEXP_REPLACE(`field`, '[\n\r]', '')

[\n\r] - This is a selection of either types of newline characters (\n for mac/unix and \r\n for windows)

GrantSmith

You can use a formula tile and the regexp_replace function:

REGEXP_REPLACE(`field`, '[\n\r]', '')

[\n\r] - This is a selection of either types of newline characters (\n for mac/unix and \r\n for windows)

ErinIbbetson

When I go to use this, REGEXP_REPLACE does not exist anymore. What can I use instead?