Can you use SUBSTRING/INDEX_OF in a query? I'm adding a calculated field and trying to display the right portion of a plain text field with these functions and get invalid calculation on everything I try.
Query is on BO "AE" , plain text field = "ManagementLevel"
AE.ManagementLevel = "85c1595f23261099073f776378263290MANAGEMENT_LEVEL_Team_Member"
example, add new calculated field "MLEVEL"
SUBSTRING( AE.ManagementLevel, INDEX_OF('LEVEL_' , AE.ManagementLevel) +6, LENGTH(AE.ManagementLevel))
SUBSTRING( AE.ManagementLevel , 50 , LENGTH(AE.ManagementLevel))
SUBSTRING( AE.ManagementLevel , 0 , 20)
All return invalid calculation.
Driving me nuts.