The cell has embedded newlines.

Hi team,

I am using below formula but as a output I am having an error as attached mentioning "The cell has embedded newlines." and I am unable to VLOOKUP the value by Find and Replace Tool. Kindly advise me how to remove this 'Embedded error' so that the new filed which came after using below formula can be used for find and replace tool and we can have correct value..

"if Contains([Hotel City Name], 'ST LOUIS') then 'SAINT LOUIS' else [Hotel City Name] endif"

Thanks in advance.

Thanks,

Mohammad Mustkeem

Capture.PNG

Error Message

Accepted answers

Emil_Kos

Hi,

Maybe try to use this formula

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

All comments

mceleavey

Hi @mmustkee ,

I'm not sure what you mean. Can you provide an example workflow of what you're trying to do?

Thanks,

Emil_Kos

Hi,

You can use the replace method in order to remove new lines from the data.

Please check this topic as this might be helpful for you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/This-cell-has-embedded-newlines/m-p/7003/highlight/true#M3943

mmustkee

Hi,

The link is not helpful. If I am using formula (REGEX_Match([Hotel City Name], 'Business\s+development')) or "REGEX_Match([Hotel City Name], '\n+', '')"

all the evalues in the column are turning to "0".

I have other values also in the column which does not have embedded error. everything is turning to "0". I want only specific values with the error should be changed to normal text so that it can be used to VLookup.

Thanks,

Mohammad Mustkeem

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335