Calculated Field Split String Capability
Would be nice to have a calculated field split string capability.
For example, if using a lookup, or managed metadata value that could be parsed with a delimiter.
Function would be split(Field Name, Delimiter, Index)
FieldValue = "Value1 | Value2 | Value3"
CalcField1 = split(FieldValue," | ", 0) // would return Value1
CalcField2 = split(FieldValue," | ", 1) // would return Value2
CalcField3 = split(FieldValue," | ", 2) // would return Value3
Thanks for your suggestion. I will update the ticket if we have anything to share on this idea.