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

Question

Posted to Laserfiche Cloud

Question

Laserfiche Cloud workflow, reformat social security number string

asked on February 4, 2020

Hello-

We have a workflow that essentially reads a QR code for metadata information.
The challenge that I am having with this workflow is applying formatting when a social security number comes across. The formatting could be this ######### or this ###-##-####

I've tried a few iterations to apply formatting
###\-##\-####
D3\-D2\-\D4

I am assuming this probably isn't the correct way to do this formatting.

Does anyone have any suggestions on how we'd "reformat" the social security number so that it contains the dashes when the string doesn't have them in it.  

0 0

Answer

SELECTED ANSWER
replied on February 4, 2020

I managed to figure it out.  Somewhat convoluted but is working none the less

The gist of it was to use the token calculator, substitute the dashes for nothing, then use another token calculator to break the string apart into 3 chunks and then put it all back together in a metadata field.  

 

Hope this helps others.

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.