I have a field in a SharePoint list that contains a string:
1)some text,2)some more text,3)sometimes text
The numbers and punctuation are included in the string as noted. The text following 1) 2) and 3) are all varying length, but always separated with commas. I need to parse this string into two variables:
Variable1=All the text between 1) and the first comma
Variable2=All the text between 2) and the next comma (before 3)
I don't need to capture the text in 3). I think I need regular expressions to do this. I've done quite a bit of other Nintex work - but never used the regular expression. I not sure how to start because several of the expressions appear to perform the same functions. Maybe something like this for the first variable?
And for the second?
Would someone point me in the right direction please? Thanks