Is there a way in beast mode to split a column by a common character?
I have a a field where the data comes in abc.123.xyz.789. My goal is to create 4 beast modes, where each beast mode will return one segment of the original field. I looked up how to do in a dataflow using substring_index, but that does not appear to be a valid function in a beast mode equation. SUBSTRING_INDEX(string, delimiter, number)
Original field: abc.123.xyz.789
Beast mode 1 result = abc
Beast mode 2 result = 123
Beast mode 3 result = xyz
Beast mode 4 result = 789
Is this possible to do in a beast mode, or do I have to run through a dataflow to complete?