Newlines detected in data

Question

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 Answer

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 (
 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], '
', '')