Removing characters from field data

Rod25
Tera Expert

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:

 

Rod25_0-1730408520081.png

 

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?

2 ACCEPTED SOLUTIONS

Murthy Ch
Giga Sage

@Rod25 

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

MurthyCh_0-1730585211083.png

Hope it helps:)

Thanks,
Murthy

View solution in original post

Shubham Gagneja
Tera Guru

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!

ShubhamGagneja_0-1730607037808.png

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

View solution in original post

3 REPLIES 3

Murthy Ch
Giga Sage

@Rod25 

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

MurthyCh_0-1730585211083.png

Hope it helps:)

Thanks,
Murthy

Shubham Gagneja
Tera Guru

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!

ShubhamGagneja_0-1730607037808.png

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

Rod25
Tera Expert

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.