Unable to split array of strings into multiple arrays of strings

[Dea_Pahumi]

Hello everyone
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.

[Yoichi]

Hi,

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

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

Regards,

[Dea_Pahumi]

@Yoichi

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

yes, that works great! thank you very much

[adiijaiin (Aditya Jain)]

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 ]+