Filter on Records that have line breaks?

[AConcernedAnalyst]

Hi all,

Wondering if anyone knew of a way to filter records with line breaks (if this is even possible)? I've tried the filters below but none work. Some records contain line breaks and some don't and I need to filter the records that do have line breaks so it can be processed a certain way. 

- Contains([COLUMN_NAME], \n)

- Contains([COLUMN_NAME], '\n')

Thank you

[DataNath]

May be \r\n rather than just \n? Can’t remember off the top of my head and not on my laptop sorry!

[AConcernedAnalyst]

@DataNath 

I tried 

- Contains([COLUMN], '\r\n')

- Contains([COLUMN], \r\n)

but neither worked. But based off your response, sounds like it is possible, which is good!

[DataNath · Accepted solution]

Hopped into Alteryx and it turns out you can actually just hit enter within your RegEx match and that does the trick! Workbook attached.

Pattern is literally: ".+<ENTER>.+"

[Qiu]

@AConcernedAnalyst 
Based on my test, the following RegEx works also.

REGEX_Match([Field1], '.+\n.+')

We can try a non RegEx approach also.