So I created 12 fields that use the following formula with the start and end variables counting the next set of braces:Let([start = Position ( plan; "}" ; 1 ; 1 ) + 1 ;end = Position ( plan ; "}" ; 1 ; 2 )];Trim ( Middle ( plan ; start ; end - start ) ))Now my only problem is that the last one doesn't end in a brace "}" and the strings vary in length, so there may not be 12 sets of values (and if there is only one set it doesn't end in a "}") I want to ammend the end variable to include the possibility of no brace. How would I do that?
Try doing it this way:
Substitute ( YourTextField ; "}" ; ¶ )
This produces a return separated list of values and then a script can loop through this list and create one record for each value in the list. (GetValue can extract one value at a time from this list.)
That was a way more elegant solution than what I was working on. Thank you. It works like a champ. To your knowledge, is there a way to sort the 'list' once you've created it? Then I can use the GetValue to pull the items in order. If not, this was still huge thanks!
If the data only exists in this one field, there is no simple method short of scripting your own sort alogrithm, but if your script is using this data to create a set of records, one per value, sorting the records produced by it is very simple.