Using Substr and expressions to find partial matches in PeopleSoft Financial Query
How to use partial matches in PeopleSoft Financials Query for use as a field or criteria.
Example public query SAB_PROJECT_LOG_ALL
On the Query tab, expand the record for CU_PG_TOT_AWARD and select the field CU_PG_ACCT_NUM.
Choose Expression tab, Click Add New Expression. Choose Character, length 3, in Expression text paste in substr(D.CU_PG_ACCT_NUM,4,3)
Click OK, then click Use as Field:
To change the column heading name, Click on the Fields Tab, then go to the bottom of the list of fields and choose Edit. Choose Text and then type a new header (make sure to leave Unique Field Name as is).
If you have more questions about this, email ITHELP@clemson.edu or call 864-656-3494.