Is there a way to crop/trim a field?

[RSAAdmin]

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:

http://1.1.1.1/event/viewnwevent.html?id=69694

And I want the field to only display:

69694

Any ideas?

[CharlesBeierle]

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).

[RSAAdmin]

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.