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

Question

Question

trim leading whitespace

asked on August 30, 2019

Is there a way to manipulate, within workflow, data being pulled from an external database? I have an instance where a particular field is being fed data that sometimes has a leading whitespace in it.

Is it possible to clean this up on my end? I do not have DBM permissions for that source.

1 0

Answer

SELECTED ANSWER
replied on August 30, 2019

Yes, in the Token Editor, there is a Function called Trim that will remove leading and trailing white space.

4 0
replied on August 30, 2019

Excuse the ignorance. How do I get to token editor in workflow designer?

 

0 0
replied on August 30, 2019

Right Click on the Token, Token Editor appears in the dropdown

2 0
replied on August 30, 2019

I found it. Thanks!!

0 0
replied on August 30, 2019

Right click on token?

1 0
replied on August 30, 2019 Show version history

When you add the token, like

%(Token) somewhere, right-click the name.

1 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.