Missing data due to "this cell has embedded new lines"

[bersocha]

Hi everyone, so I'm trying to capture some tickets information from a SQL database but I'm not being able to capture all the text. As you can see in this example in the last part of the sentence "Can you please ad....." there is text missing and is happening in every record. 

I've already tried to add a REGEX formula but the issue persists: REGEX_Replace([Field1], '\n', '')

I tested the query on Power BI and it´s working perfectly, the issue is with Alteryx.

[flying008]

@bersocha 

Maybe you can change the field size to adjust the string length first.

[bersocha]

I already tried it and issue persists..... 

[Prometheus]

@bersocha Make sure that your RegEx formula has the correct field: REGEX_Replace([value], '\n', ' '). I would also replace the embedded newlines with a space unless it doesn't matter whether or not your value is concatenated.