Remove Line Break

Some of my source data has line breaks which seems to be causing issues with the integration.
Is there a transformation step that can be used to remove line breaks?

Hey @Annika_Cederblad - I recommend using the Use regex step for this. Try setting up your regex step like this:

\n should identify line breaks across all of your columns. I put a space in the Replace Value field so that my line breaks are replaced by a space. Data with 2 line breaks will be replaced by 2 spaces.

Let me know if that works!

1 Like