Removing characters from field data

[Rod25]

Hello,

I'm trying to create a filter, based on the incident table, where it looks at the data in the short description field.  I've learned that the short description data has a date appended to it.  This is how the incidents are being created for this particular scenario.  Please see below:

File Validation 10/10/2024

When the filter is created, it appears as the following:

I would like to know if there is a way to only search on the string "File Validation" and not include the date? The reason for this ask is because I'm trying to generate a report that only shows incidents with the description of File Validation.  If it shows the date, I will get different occurrences of File Validation when I only need to see one.  So, to restate my question, is there a way to only search on the string "File Validation" and not include the date?

[Murthy Ch · Accepted solution]

@Rod25 

You can try something like below to get desired results as you expected:

Hope it helps:)

[Murthy Ch · Accepted solution]

@Rod25 

You can try something like below to get desired results as you expected:

Hope it helps:)

[Shubham Gagneja · Accepted solution]

Hey @Rod25 ,
Hope you are doing well! 
You can create a report OOTB in the report module by navigating to the View/Run Report Module from application navigator!
Try these filters out!

This will give you the right outcome!
Please mark my answer if you find it helpful.
Thanks
Shubham

[Rod25]

Thank you everyone for your responses.  I believe you all replied with the same ideas for me to try.  It worked.  Good day to you all.