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

Question

Question

Remove white space in metadata field with Workflow

asked on September 30, 2021 Show version history

I have checkbox values that come in from a LF form. They come over as: V_1, V_2, V_3, V_4, V_5...

When these documents hit the repository, I have a workflow that will remove the "V_" values and keep only the numbers.

However, I still have whitespace in-between these values that I cannot remove (I.e." 1,  2,  3, 4, 5...). I need it to be: 1,2,3,4,5. 

Attached is the token formatting I am using. Is there another function I need to add to remove this space? 

 

Token Editor.PNG
Token Editor.PNG (18.28 KB)
0 0

Answer

SELECTED ANSWER
replied on September 30, 2021

I would use Token Calculator and substitute them with empty strings instead:

SUBSTITUTE( SUBSTITUTE(%(Token 1),"V_"  ,"") ," "  ,"" )

 

SUBSTITUTE(%(Token 1),"V_"  ,"") will turn V_1, V_2, V_3, V_4, V_5 into 1, 2, 3, 4, 5. Then the second round of substitution takes out the spaces.

0 0
replied on October 1, 2021

This works great. Thank you!

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.