SUBSTRING/INDEX_OF in Query

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
KnightWare
Posts: 139
Joined: Sat Feb 10, 2018 12:56 am

SUBSTRING/INDEX_OF in Query

Post by KnightWare »

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.
Post Reply