You are viewing limited content. For full access, please sign in.

Question

Question

Workflow - Substitute special characters out of a token

asked on March 5

Hello,

I build a token within a workflow, and after it's built, I'd like to remove special characters from it. The Substitute formula in the Token Calculator activity is simple enough when there's one character to look for and replace, but if there's multiple special characters I'd like to replace with nothing, what's the easiest way to do that?

For example, right now, I have the following to substitute & with nothing:

SUBSTITUTE(%(TokenName),"&","")

If I wanted to exclude & and * and \, what's the easiest way to do that?

Thanks!

0 0

Answer

SELECTED ANSWER
replied on March 6

You should be able to chain the Substitute function for multiple replacements

 

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(%(TokenName), "&", ""), "*", ""), "\", "")

 

2 0
replied on March 6

Ah, makes sense. Thanks!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.