Reading values from text strings

[tww]

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 solution]

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