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

Regex

Output

Custom Tools

Parse

Accepted answers

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>.+"

Address Regex Parse.yxmd

All comments

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

AConcernedAnalyst

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!

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

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

We can try a non RegEx approach also.

0505-AConcernedAnalyst.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703