Skip to Content
Dec 13, 2022 at 06:24 AM

How to trim sentence into new field in webi

154 Views Last edit Dec 13, 2022 at 11:26 AM 2 rev

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?




image.png (4.3 kB)
image.png (1.3 kB)