Forum Discussion
It is probably possible to create multiple child records, using Regex syntax in a pipeline, but that might be a little too fancy for both of us.
Assuming that there is some practical limit on the number of step strings like say 20 or even 50, it would be possible to use either a series of separate fields or one giant field with formula variables, and it would use the FIND function to locate the first occurrence coming out the string from the left. Then you could extract off the first one and then use the NotLeft function to hive off the string up to the end of the first stp string, then repeat the process like 20 times.
Each of the extracted strings would be in a separate form of variable, and then you would use the list function to list them all together, separated by a comma space
- dyarosh3 days agoQrew Member
I was hoping I could do it within the formula and not have to resort to using a pipeline.