Reading values from text strings

Question

Hi all,

I have a description field that I would like to extract some values from. See example below. Could someone show me on how to get the output that I am looking for?

Input

Please update the following as discussed........

Term Date: 8.23.2021

Last Date Worked: 8.18.2021

Associate Name: Anella Peokine

Emp ID: 0195SYT

Position Title: Relationship Manager

Output

Associate Name

Emp ID

Term Date

Position Title

Anella Peokine

0195SYT

8.23.2021

Relationship Manager

Thank you

TWW

Qiu · Accepted Answer

@tww 
If we can assume there is always colon ":" in your data field, we can parse the data as below.