joshua-r2
10/17/2017 - 5:59 PM
Criteria - Functional Location Subsection
How to extract a section of the Functional Location given that it is tiered and separated with "-".
SUBSTR([Equipment].[Functional Location], (Instr([Equipment].[Functional Location], '-', 1, 1) + 1), ((Instr([Equipment].[Functional Location], '-', 1, 2) - Instr([Equipment].[Functional Location], '-', 1, 1)) - 1))