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
Hey @sachi ! Just came across this and wanted you to know it was very helpful .
1 Like