Extract Sentences between periods

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.

Thanks,

Alternator

Parse

Accepted answers

All comments

atcodedog05

Hi @The_Alternator

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

Workflow:

Hope this helps : )

Sentences.yxmd

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,

mceleavey solution_text parsing.yxmd

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