Provided that CalculatedField4 has a fixed number of string segments within the string, in this case five, then this formula isolates the text ending in "BH":
)[/code]Reversing the logic, this will effectively strip the "BH" text from the original text:
Also, for a variable number of entries on each line, you would have to know the maximum number of segments in advance of building the formula, or have an upper limit and build to that.
Breaking the data out using a multi-column region and then creating a summary could give you an automated approach but it would likely require a two pass solution.
PS Chickenjoy, I notice that some of your posts refer to Monarch v9, some to Monarch v10? Why not upgrade the v9 users to v10, so that they could use the Column() function to solve problems like this?
Indeed, the only "cost" of building extra capacity with the given formula would be a little extra calculation overhead. The series could be extended to handle, say 100 segments, with only a little more copy/paste/revise work.
The split functions are very forgiving if you specify more segments in the function than actually exist in the data.