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

Question

Question

Adding a mask to field values

asked on March 5, 2019

My office is adding a twelve-digit number in a new field (###-###-###-###). We would like to just store the numbers without the dashes. Is there a way to create a mask on the field or would a regular expression do what we want?

0 0

Replies

replied on March 5, 2019

Hi Michael,

You could use Pattern Matching to obtain the result you want.

Apply the Pattern: ([^\-]+) and make sure to select "All matches (combine with no spaces)".

Thanks.

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

Sign in to reply to this post.