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?
解決済! 解決策の投稿を見る。
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', '')
Like a charm! Thank you so much for this.