Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Is there a way to parse out the first line of a paragraph from an excel cell?

wonka1234
10 - Fireball

Hi,

 

Say I have cells like this -

 

Paragraph C1 - C33 of the Document
Blah blah blah blah

 

Can I parse out the first like of the paragraph so I only get :

Paragraph C1 - C33 of the Document
3 REPLIES 3
DataNath
17 - Castor

@wonka1234 if it's always just the first line then you'll be able to use a Formula tool with this expression:

 

REGEX_Replace([Input], '([^\n]+)\n.*', '$1')

 

Which just isolates everything before the first instance of a line break.

csmith11
11 - Bolide

You can parse the column using text to column tool. The delimiter you want to use is \n. This will push the first line into the first column and then you can deselect any subsequent columns.

 

Example.png

 

 

binuacs
20 - Arcturus

@wonka1234 One way of doing this

image.png

Labels