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

Question

Question

Regular Expression Assistance

asked on August 12 Show version history

Hello,

I'm guessing this is a simple request, but for some reason I cannot figure it out.  I want to use a regular expression to isolate the numbers in the parentheses at the end to create a new token.

 

10325 - _Dorian, John - Financial Planning Engagement Letter - 8/12/2019 - UNSIGNED (830388)

 

Thanks!

0 0

Answer

SELECTED ANSWER
replied on August 12 Show version history

The end result may seem simple, but knowing how to express what you need in regular expressions is not so simple. Don't worry about it. Even people who write them all the time tend to look up a reference for all but the most basic expressions.

There are many ways to do what you're after, but here is one that should work in Workflow.

\((\d+)\)

\(    = Start by matching the literal character "("
(     = Everything after this will be captured into a group
\d+   = One or more "digits"
)     = the end of the group
\)    = Match the closing ")"

Basically, only the digits inside of the inner parentheses will be captured by Workflow. You'll want to test it out on a variety of document names, but this should work for you.

If the number inside the parentheses is always the same number of digits, you can do something like this.

\((\d{6})\)

\d{6}    = Match exactly six digits

\d{6,}   = Match six or more digits

\d{6,8} = Match from six to eight digits

 

7 0
replied on August 12

Awesome, Devin!  Thanks so much.

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.