Answered

Split text - capitalised phrase - split text with inbuilt conditions

(0) Share

Report

Posted on by 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) ?

Categories:

General topics

I have the same question (0)

All responses (15)

Answers (2)

Sort by

Verified answer

SamLed 2,340 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @StillLearning_,

Here's a working method:

From expression: split(replace(outputs('Compose'), ',',''), ' ')

Note: It replace any comma par space then split by space to get an array of words

Filter condition expression (use advanced mode): @and(equals(item(), toUpper(item())), greater(length(item()), 1))

Note: it checks for each word if word equals its capitalized version and if it is greater than 1 char to exclude non word.

Results:

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
StillLearning_ 38 on at

Like (0)

Report
Copy link

Link copied!

so this is working now (I can extract the capitalised words) but I can't seem to do anything with them now - the 'split text' function doesn't seem to work on the output of this ?

The result being that when I try and use the capitalised words later in the flow, it either doesn't work at all or I get this: ["SMITH","PHILLIP","GRACE"] rather than SMITH, PHILLIP, GRACE

Are you able to assist in explaining how I can split the text, once it returns in the above 'array' ?

Was this reply helpful? Yes No
StillLearning_ 38 on at

Like (0)

Report
Copy link

Link copied!

Also - is there a way to adjust the formula to do the same thing for the lower case words (Timothy, Fairmont, Sally-Louise)?

Was this reply helpful? Yes No
SamLed 2,340 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @StillLearning_,

Expression:

@and(and(not(equals(item(), toUpper(item()))), greater(length(item()), 1)), and(not(contains(item(), '(')),not(contains(item(), ')'))))

and(not(equals(item(), toUpper(item()))), greater(length(item()), 1)) part exclude any Upper cased item and 1 char length ones.

and(not(contains(item(), '(')),not(contains(item(), ')') excludes any item containing '(' or ')'.

results:

[Edit] I corrected expression, bad copy/paste, added missing right parenthesis.

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
SamLed 2,340 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @StillLearning_ ,

To convert string into array you use split(string, separator), to revert the conversion use join(array, separator):

expression: join(body('Filter_array'), ',')

Results:

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
StillLearning_ 38 on at

Like (0)

Report
Copy link

Link copied!

I have tried this expression - with the same "from" formula:
split(replace(outputs('Compose'), ',',''), ' ') - but it is telling me it is invalid ..

Was this reply helpful? Yes No
SamLed 2,340 Moderator on at

Like (0)

Report
Copy link

Link copied!

That's the filter expression which is failing not the from one, it lacks a parenthesis between the 2 first and 😉

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
StillLearning_ 38 on at

Like (0)

Report
Copy link

Link copied!

Sorry please forgive my ignorance (you have been so helpful!) - what is it I am missing ?
This is what i am trying, but it is giving me the above 'invalid' result..

From: split(replace(outputs('Compose'), ',',''), ' ')
Expression: @And(and(not(equals(item(), toUpper(item()))), greater(length(item()), 1)), and(not(contains(item(), '(')),not(contains(item(), ')'))

Was this reply helpful? Yes No
SamLed 2,340 Moderator on at

Like (0)

Report
Copy link

Link copied!

Don't worry, I'm glad to help 😉

in your sceenshot, I highlighted where it lacks a "(":

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
SamLed 2,340 Moderator on at

Like (0)

Report
Copy link

Link copied!

Lacks also one ")" at the end, I think

Was this reply helpful? Yes No