How to trim sentence into new field in webi

Hi All,

I have a description column in report.

Case is pending with FE CASE NO: 02995F14 FIELD CC21177653:1/1 - SCHED: A - CSE HRS: 02:00 - FE: 06.10.21 CONTRACT END DATE: 30.09.22 / CSE SKILLS: LEVEL0 NO TOOL NEEDED

I want to trim CONTRACT END DATE: 30.09.22 from description sentence into new column as END DATE with date only in it.

e.g END DATE: 30.09.22

expected output:

This End Date is from Contract End Date of Description column.

Can somebody help me with this please?

Thanks,

Bhagya