Unable to split array of strings into multiple arrays of strings

Hello everyone :slight_smile:
I need help with my automation, I have an issue with the last part of it. I will be receiving a larger String variable with multiple strings inside it separated by a ; which I later split into a new variable of an array of Strings. The next step which is not working for me is I need to split all the words separately into another array of Strings.
Example: in_familyList = β€œ7654321-5 John Doe - 1993-08-21;1234567-5 Jane Doe - 2000-01-01”
in_familyMembers = β€œ7654321-5 John Doe - 1993-08-21”, β€œ1234567-5 Jane Doe - 2000-01-01”
in_familyKey = β€œ7654321-5”, β€œJohn”, β€œDoe”, β€œ-”, β€œ1993-08-21”, β€œ1234567-5”, β€œJane”, β€œDoe”, β€œ-”, β€œ2000-01-01”
Workflow.xaml (14.3 KB)
Here is the workflow just to have a clear idea of what I have so far, I added also an index variable since the initial in_familyList parameter may have more than 2 familyMembers inside it.


I think we can directly get the array using the following expression. Can you try this?

 in_familyList.Split({" "c,";"c},StringSplitOptions.RemoveEmptyEntries)



yes, that works great! thank you very much :smiley:

1 Like

Hi @Dea_Pahumi,
Do you just need the names of people written in there?
if So you can use Regex to get it

For Getting the name: [a-zA-Z ]+

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.