Reporting Wildcards

[balmasa]

I would greatly appreciate any help you can give me with this topic:

We have in our keys multiple dimensions, for example 

First 3 digits: function

4th Digit: grade

5th Digit: Cost Category

6th-8th Digit: Project

9th-10th Digit: Location

The question is whether there are wildcards that would allow us to report on specific grades or even projects without having to do Excel data dumps to isolate the different dimensions.

For example, I'd like to find all the keys that have a 3 in the 4th digit.  In Excel I would be able to look that up as ???3*, or ???3??????.

Thank you for your responses!

[JyotishkaB]

Hi @balmasa 

To assist you further, would you please confirm the PowerSchool product you are referring to?

[balmasa]

Thank you very much!  I got the answer to my question and it was for BusinessPlus, CDD reports.

The wildcard to use for searching for specific characters within a key, but every other character in every other place is:  underscore _  so to find the 3 in my example above, you'd have to type 3 underscores and a 3, followed by an asterisk *  that is, you'd have: ___3* as the solution for my question above.

Thank you!

Al