parse out the data from a single cell

[Haokun]

hi regex lovers,

below is my data set, all the information is in 1 single cell and i wish to parse out the information contains entity/employer/company into another column. 

Input data (there are 2 records, each record is in a single cell)

Submission due to AD2020 Business Interests Name of Entity: abc Insurance Agency (S) Pte Ltd Place of Incorporation/ Establishment: Singapore Nature of Business: Insurance  Business Interests:  Sole Proprietor Date of Acquisition: Date of Cessation: 2020-09-15

Concurrent Employment Name of Employer: BCD Cathedral Nature of Business: Church Job Title: Senior Pastor Nature of Duties: search and groom a successor Date of Commencement: 2022-08-14

expect output

abc Insurance Agency (S) Pte Ltd

BCD Cathedral

[ShankerV]

Hi @Haokun 

One way of doing this.

Input was:

Many thanks

Shanker V

[ShankerV]

Hi @Haokun 

Step 1: Input

Step 2; Record Id

Step 3:

Many thanks

Shanker V

[ShankerV]

Hi @Haokun 

Step 4: Filter tool.

Contains([Field1],"entity") or
Contains([Field1],"employer") or
Contains([Field1],"company")

Step 5: Regex tool.

:(.+)

Step 6; 

Many thanks

Shanker V