Skip to main content

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,

Hi

Can you explain your requirement a bit further? What are you evaluating to get the char?


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


This is brand new information! Who knew you could run regex in a set a condition action?!


Reply