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

adolven
adolven Member
edited August 2023 in Magic ETL

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:

Screenshot 2023-08-10 182729.jpg

Excel:

Screenshot 2023-08-10 182511.jpg

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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)

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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)

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ErinIbbetson
    ErinIbbetson Member
    edited January 2024

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

Categories