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!
To assist you further, would you please confirm the PowerSchool product you are referring to?
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.