Extract Sentences between periods

[The_Alternator]

I'm looking to make every sentence of a text into a new column. You can think of the text as a normal paragraph, sentences separated by periods. So for example, I have this text:

WHEN THE VIRUS IS INSIDE THE BUILDING - MONTANA FREE PRESS GET THE WEEK'S TOP STORIES. SUBSCRIBE TO THE NEW MONTANA LOWDOWN. SIGN UP FOR OUR FREE WEEKDAY NEWSLETTER.

I want this text broken out into individual sentences in a new column (on new lines) like this:

Column1

WHEN THE VIRUS IS INSIDE THE BUILDING - MONTANA FREE PRESS GET THE WEEK'S TOP STORIES.

SUBSCRIBE TO THE NEW MONTANA LOWDOWN.

SIGN UP FOR OUR FREE WEEKDAY NEWSLETTER.

Thanks,

Alternator

[atcodedog05]

Hi @The_Alternator 

You can use text to column tool and formula tool for this.

Workflow:

Hope this helps : )

[mceleavey]

Hi @The_Alternator ,

I've built this to accommodate any number of "." in the text.

The first browse tool shows the data split to rows and the second is split to columns.

Hope this helps,

M.

[The_Alternator]

Hello @atcodedog05 

Thank you for the response. This is what I was looking for. However - let's say I want to ignore certain periods for abbreviations. For example, I have a sentence that contains "U.S.":

SECTION 504 PLANS SPECIAL EDUCATION STATEWIDE TESTING U.S. SENATE.

Currently it's making "S" as its own sentence, when really I want to ignore that those periods. Any ideas?

[mceleavey]

@The_Alternator ,

not without building a reference table manually. For example, you could build a table with a list of words you wish to ignore, then can match the text to the reference table.

There's no way for Alteryx to really know which is which.

M.

[atcodedog05]

Hi @The_Alternator 

You would have to have a list of words and change them like below. There is no other way.

Workflow:

Hope this helps : )

[mceleavey]

@The_Alternator ,

I've built an example of how you can do that:

Hope this helps,

M.

[mceleavey]

mine changes it back to the original, but aside from that pretty much the same as @atcodedog05 's

Great minds 😉

[atcodedog05]

Hi @The_Alternator 

Updated solution with keeping U.S. as same.

Workflow:

Hope this helps : )

[atcodedog05]

@mceleavey 

Updated and covered that too 😉