parse out the data from a single cell

Question

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-15Concurrent 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 LtdBCD Cathedral

ShankerV · Answer

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

ShankerV · Answer

Hi @Haokun

Step 1: Input

Step 2; Record Id

Step 3:

Many thanks

Shanker V

ShankerV · Answer

Hi @Haokun

One way of doing this.

Input was:

Many thanks

Shanker V