Extract some words from a data set.

[Ar13f]

Dear All,

I hope all communities are in good health ...

Kindly need your help from you guys.

I have a role data like below and I want to only want to take some roles as written in the "Result" column.

Current Role Description	The Result
Proprietors,Beneficial Owners,Authorised Signatories,Approving Signatories	Beneficial Owners,Authorised Signatories,
Authorised Signatories
Directors,Shareholders,Authorised Signatories,Approving Signatories	Directors,Authorised Signatories
Directors,Beneficial Owners,Shareholders,Authorised Signatories,Approving Signatories	Directors,Beneficial Owners,Authorised Signatories,
Directors,Authorised Signatories,Approving Signatories	Directors,Authorised Signatories
Directors
Shareholders
Approving Signatories,Authorised Signatories,Directors,Shareholders	Authorised Signatories,Directors,
Approving Signatories,Authorised Signatories,Beneficial Owners,Director,Shareholder	Authorised Signatories,Beneficial Owners,Director,

Thanks a lot for the help.

Regards,

[Qiu]

@Ar13f 
Can you introduce your logic here?
I dont see a pattern...

[Ar13f]

Hi Qui,

thank for your response and question ...

the logic is :

From the "Current Role Desc" column data actually I only need "Authorised Signatories" but apart from that it has to be seen if this person has any other role.

for example :

This person have role are Proprietors,Beneficial Owners,Authorised Signatories,Approving Signatories so I take Beneficial Owners,Authorised Signatories

and  Directors,Beneficial Owners,Shareholders,Authorised Signatories,Approving Signatories, I take Directors,Beneficial Owners,Authorised Signatories

I hope you can understand what I want.

regards,

[Ar13f]

sorry there is 1 more additional logic

while for people who have 1 role even though he is "Authorised Signatories" is ignored.

[CarliE · Accepted solution]

@Ar13f 

Attached is a workflow

What I did was counted how many commas there was, if there were none, i left the field alone. If there were more than 0 I looked up if any of the roles that are bolded above are in the record. After that, I consolidated.

Please mark as a solution if this solved your problem :)

Thanks!

[Ar13f · Accepted solution]

Dear @CarliE 

sorry for late respon ....

Thank you so much for your help and advice ...

Thank you for all members ...

regards,