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!
Solved! Go to Solution.
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
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?
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