Does anyone know if there is a way to create a report to limit characters of a column? Lets say I want to see the last update comments but they ar elong, is there a way to limit what I see on the report like 20 characters? | Community
Skip to main content
C
CourtneyWe1
Level 2
May 18, 2021
Question

Does anyone know if there is a way to create a report to limit characters of a column? Lets say I want to see the last update comments but they ar elong, is there a way to limit what I see on the report like 20 characters?

  • May 18, 2021
  • 1 reply
  • 513 views

Does anyone know if there is a way to create a report to limit characters of a column? Lets say I want to see the last updated comments but they are really long, is there a way to limit what I see on the report like 20 characters? I can't seem to find text edits to include in the report itself. I tried to use the count to unique or distinct items but it didn't work.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
May 18, 2021

Hi Courtney - Do you know about WF-Pro.com? @NRYN R - inactive‚ built it and it is a must-save-to-your-favorites. He actually has something that might be perfect for you. He limited it to 140 characters but you could adjust that if you need it to truly be 20.

displayname=Last Note

querysort=lastNote:entryDate

textmode=true

valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open for more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0, CONCAT({lastNote}.{noteText}," -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate})))

valueformat=HTML

Direct URL to his text mode examples: https://wf-pro.com/home/training/text-mode-examples/

    Terms & ConditionsAccessibility statement

    Loading footer...