Creating a column in a report using text mode | Community
Skip to main content
April 22, 2025
Solved

Creating a column in a report using text mode

  • April 22, 2025
  • 1 reply
  • 552 views

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!

Best answer by skyehansen

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/calculated-data-expressions 

 

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

 

 

1 reply

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
Community Advisor
April 22, 2025

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/calculated-data-expressions 

 

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

 

 

CamiDAuthor
April 22, 2025

Thank you so much! It worked!