Is there a way to crop/trim a field?
I am working with the DLP report for Incidents By Users and would like to have EventDescription return only the number after the ID.
For example, right now the field is showing:
And I want the field to only display:
Are you wanting to do this in the WebUI or Event Explorer? I am pretty sure EE will allow it using the builtin sql functions but the WebUI is probably a bust. Post what you are using and I will see what I can do (if anything).
unfortunately this is in the WebUI in the ad hoc report creation. The customer doesn't want to see the entire link, just the ID. In some searches I saw that SQL itself has RTRIM and LTRIM commands, but they only remove whitespace before and after the contents.