Hi kdavis4,
You are right with using a regular expression for this. For your scenario I would recommend to use the regular expression with 'split' operation. As comma is the separator in your string you have to define the pattern with ','. The result you must store in a workflow variable of type 'Collection'.
As result your string is then saved in three values in the workflow variable, looking like this some text;some more text;sometimes text.
The next step is getting the required parts out of this workflow variable. For this purpose you can make use of 'Collection Operation' action with 'Get' operation. To configure this action you have to create three workflow variables:
- Variable 1 - for Index (Type: Number)
- Variable 2 - for the first string (Type: Text)
- Variable 3 - fot the second string (Type: Text)
Then add the following actions:
- add a 'Set a variable' action and define 'Variable 1' with '0' to point to 'some text' in your collection variable.
- add a 'Collection Operation' with your collection variable as target collection, index: 'Variable 1' and store result in: 'Variable 2'.
- add another 'Set a variable' action and define 'Variable 1' with '1' to point to 'some more text' in your collection variable.
- add another 'Collection Operation' with your collection variable as target collection, index: 'Variable 1' and store result in: 'Variable 3'.