Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subj
SummaryExtract Cost Center from "Code Combination Descpription" field
I am using "Code Combination Description" field as one of my select columns from (Procurement - Spend Real Time) subject area. It is available under Procurement - Spend Real Time >> Invoice details >> Distribution Combination >> Code Combination Description.
Primarily I would like to check the No.Of Invoices entered and No. of Invoices Paid under a specific Cost Center.
Currently, the value under "Code Combination Description Field" appears like HOV.LOB.POP CENTER.EXPENSE-VISION.DEFAULT.DEFAULT.DEFAULT.DEFAULT). Now, I would like to extract only "POP CENTER" which is the 3rd Segment in Code Combination Description field separated by "."