Newlines detected in data

[oracleoftemple]

I think I know why I'm getting this message.  I believe there are line breaks in some cells, i.e., someone pressed the equivalent of Alt+Enter in Excel.  So I think Alteryx is making a new line because it's interpreting these line breaks in this way.  Is there a way to detect line breaks within a cell and remove them?

[DataNath · Accepted solution]

Hey @oracleoftemple, here's a couple of formulae you can use to tackle this. The first is just a standard replace where you literally just hit enter in the target, hence why the expression moves to a second line. The second uses RegEx to look for a pattern (\n in this case which represents a line break). In both cases we just replace the target with '' i.e. nothing:

Replace([Input], '
', '')

REGEX_Replace([Input], '\n', '')

[oracleoftemple]

Like a charm! Thank you so much for this.