Is there an available function to convert a Char to it's ascii value?
End result: I want to be able to compare two characters (so I can assign tasks by alphabetical range).
Thanks,
+2
Hi,
The Requirement:
(A Tasklist) I'd like to auto-assign all new Employees with surnames begining A~I, to Team A, and surnames J~Z to Team B.
To do that I'm extracting the first character of the surname and trying to compare with ascii values to determine greater or less than.
I'd also appreciate any approaches to this workflow.
Hi Moses I
This is how i would approach this
First of all I have a Build String action configured:
This would give me the first letter of the title field in upper case
eg Crawford, Paul = C
Next i have a Set a condition action configured:
The regular expression matches and character between A-I
This evaluates the variable and if it matches the regular expression the workflow will continue down the yes branch, if not it will continue down the no branch.
Yes - assign A-I to team A
No - assign J-Z to team B
Hope this helps
+16
This is brand new information! Who knew you could run regex in a set a condition action?!
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.