Inline function fn-Substring errors with special characters

  • 26 March 2021
  • 0 replies
  • 455 views

Badge +3

Issue

When using fn-Substring with a workflow variable that contains a special character (i.e : comma, single quote, double quote, etc), the inline function is not working as expected. This behavior is exhibited by a return of the the function and parameters as an entire string.

 

Example:

Setting a String Workflow Variable named "VarString" to "The following string has a number of special characters, Like: @#%&"

 

and running the following sub string function:

fn-Substring({WorkflowVariable:VarString},10,5)

 

Returns the following value:

fn-Substring(The following string has a number of special characters, Like: @#%&,10,5)

 

Resolution

Depending on case usage, the regular expression workflow action could be utilized instead, or if need be used to remove any special characters from the string. The example below uses the pattern of w, which will match any alphanumeric character. This will return a string with no special characters.

 

9958iA5EE880D2E6B64F3.png

 

 

Related Links


0 replies

Be the first to reply!

Reply