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

Question

Question

Phone Number Formatting

Quick Fields Pattern Matching and Regular Expressions
Updated April 5, 2022
asked on April 5, 2022

Hello,

I am creating a Quick Fields session that extracts the phone number. The format is (xxx) xxx-xxxx. I have tried creating a token to remove the parenthesis, spacing, and dashes without luck. Any suggestions?

Thanks!

0 0

Answer

SELECTED ANSWER
replied on April 5, 2022

Your best option is probably to use the Substitution activity.

That activity allows you to replace characters based on pattern matching, and if you check the box at the bottom it will store the result back to the input token.

In the following example, the pattern is replacing any non-digit character with nothing, which will remove the parentheses, spaces, and dashes.

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

Details
Related Posts
Loading ...