Split Text based on CAPITALISED words OR split text based on number of comma's (i.e. if 1 comma do X if 2 comma's do Y etc)

[StillLearning_]

Hi all!

I am hoping someone can help me figure out this issue.  I want to be able to extract (split) text (event subject) that could look like any of the below: 

EXMAPLE 1: BLOGGS, Joe (Meeting - Office) 

EXMAPLE 2: BLOGGS, Joe, DOE, Jane (Meeting - Offsite)

EXMAPLE 3: SMITH, Timothy John, PHILLIP, Fairmont, GRACE Sally-Louise (Monthly Update - Richmond Office)

The results I ultimately want are:

function1: 

EXMAPLE 1: BLOGGS 

EXMAPLE 2: BLOGGS, DOE

EXMAPLE 3: SMITH, PHILLIP, GRACE 

function 2: 

EXMAPLE 1: Joe

EXMAPLE 2: Joe, Jane 

EXMAPLE 3: Timothy, Fairmont, Sally-Louise

I need the last name and first name in separate functions because they are used separately later on in the flow. 

Currently, I have a function that works for EXAMPLE 1 - 

Compose: split(triggerOutputs()?['body/subject'], ' ')[0]

which results in:    BLOGGS,

Compose: split(outputs('SURNAME_(with_comma)'), ',')[0]

which leaves me with:    BLOGGS

This works perfectly where there is only 1 name in the subject (as in EXAMPLE 1) .  However I can't figure out how to extract this if there is more than 1 name.

Ultimately my question is - is there a way to extract only the ENTIRELY capitalized words? and/or is there a way to extract the first word immediately after a comma (even where there are multiple commas, like in EXAMPLES 2 and 3) ? 

[AlexEncodian]

@StillLearning_ 

To return all capitalised words, you can use Encodian's Utility - Search Text (Regex) action:

Using the following Regex Query:

\b[A-Z]+\b

To return the word immediately following a fully capitalised word followed by a comma and space or just a space, handling hyphenated words, run the following query using Encodian's Utility - Search Text (Regex) action:

(?<=\b[A-Z]+\b[,\s]+)(\w+(?:-\w+)?)

You can use ChatGPT to help you write Regex queries to really match any pattern. Its an incredibly powerful text extraction tool. Definitely test your regex queries before using them. You can test them using a tool like RegExr: Learn, Build, & Test RegEx

Note, Encodian's "Utility" actions (those prefixed utility in the name) only consume 0.05 credits per run. So on a Standard Encodian plan, you can run these actions 10,000 times.

[StillLearning_]

Is there a way to do this without additional programs? 

[Matthy79]

Is it a typo that there is no comma between GRACE and Sally-Louise in Sample 3 or could this happen all the time? Could there also be double names with space that should be together? Is "(" always the sign to end up searching for names?