Creating a column in a report using text mode

[CamiD]

Hi All,

I'm currently working on a Task report where the tasks descriptions contain the iteration ID. Is there a way to create a column in the report to filter out only the ID from the description using text mode? If so, how would that look like?

This is how the description looks like: 

20203363 | R10 | T33 - Description - Submission date

I'd like to add a new column with only the values before the first "-"

Thank you!

[skyehansen · Accepted solution]

I got the following from copilot after feeding it some expectations from out of the calculated data expressions page here:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/... 

displayname=Extracted Text
textmode=true
valueexpression=LEFT({description}, SEARCH("-", {description}) - 1)
valueformat=HTML

[CamiD]

Thank you so much! It worked!