Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Regex Line Break

kgordish
8 - Asteroid

Hello, 

I need some assistance with Regex and line breaks. Reading some older posts, but the Alteryx interface has changed over time.
Trying to insert line breaks within a cell after a comma.

 

Thank you in advance. 

 

 

Regex.JPG

2 REPLIES 2
nagakavyasri
12 - Quasar

@kgordish You can use TextToColumns tool:

 

Screenshot 2024-02-26 141634.png

danilang
19 - Altair
19 - Altair

Hi @kgordish 

 

If you want your line breaks to be within the current cells use \n as the Replacement Text.  Also your matching text should include a trailing space in the Regular Expression ", " to remove the leading space from the second row onwards.

 

c.png

 

R.png

 

Dan

 

 

Labels
Top Solution Authors