Split List According to first letter of a String (Name)

[LeandroGAmaya]

Hi Community, hope you're all having a great week.

I've been asked to build a Workflow and, at some point, I'm needing to separate the list according to the names displayed. I'd need two outcomes, one with everyone whose name starts with [a,k] and the other with [l,z].

I've tried with the StartWith() formula but I'm not finding the way of doing so with a range of characters.

Thank you beforehand!

[ShankerV]

@LeandroGAmaya 

One way of doing this.

[ShankerV]

Hi @LeandroGAmaya 

As I have seen your question with lowercase letters, the filter tool is not case sensitive.

So It will output you both name starts with Lowercase a and Upper case A.

Many thanks

Shanker V

[LeandroGAmaya]

Hi there! 

Thank you a lot for your answer. I haven't explained it well enough, I need to separate the list with every person whose name starts with a letter from A, all the way to letter K. Meaning that somebody named Carol should appear but Leonard shouldn't. Is that something that can be done without doing individually?

[ShankerV]

Hi @LeandroGAmaya 

Please find the expected result.

Note: As join tool is case sensitive, I have converted the starting letter to Uppercase while joining. 

Many thanks

Shanker V

[binuacs · Accepted solution]

@LeandroGAmaya One way of doing this with the Regex function