The issue with that approach is the number of "stp" strings is unknown. If QB formulas supported looping it would be easy to solve.
Qrew LegendWell, while there is a limit to how long the formula can be in QuickBase, I hear it's quite an absolute limit. So you could certainly just keep building the formula to extract say 50 of those strings. But if you truly want unlimited looping then I need you think you need a pipeline with a Regex solution. Contact me directly if you want some ideas of a developer who could write that syntax.
Thank you. I know I can do it in a pipeline but was hoping not to have to.
