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

Question

Question

Extracting information from a field

asked on July 7, 2015

I am working with workflows.  I have retrieved an account number, but I need to pull two sets of numbers out of the account number.  Can this be done?  Example is shown below...

 

Account number is 98745612345

I need the first 2 digits (98) as a set, and the third and fourth digits (74) as a set.

The extracted numbers will be used to route the document to the appropriate folder.

0 0

Answer

SELECTED ANSWER
replied on July 8, 2015 Show version history

use the token twice, 

On the first token, use the Token editor to add something like this to the regular expression:

^(\d\d)

and for the second token, use the following regular expression:

^\d\d(\d\d)

OR:

^(\d{2})
^\d{2}(\d{2})
1 0

Replies

replied on July 7, 2015 Show version history

If I understand this correctly, you are going to route the document to folder 98 and then within folder 98 it is going to folder 74? if this is the case here is what you need. THe field I used for the example is a multi-value field so ignore the "All" part of the field 

1 0
replied on July 9, 2015

The second response worked for me. 

Thanks.

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

Sign in to reply to this post.