Question

How do I truncate information within a token?

Quick Fields Workflow

Updated September 29, 2014

asked on September 26, 2014

I have a token with the following information 07/10/2014 10:16abcdefghij I wish to create either another token or use a substitution to capture only the year (2014) portion of this data so that I can use only the year as a new token to dictate which folder the document needs to move to when being stored in the repository.

0 0

Answer

SELECTED ANSWER

replied on September 29, 2014

Hi Jeff,

The picture that Sierra pasted is actually from an old user interface. It's actually just that check mark icon.

If you hover over it, it says "Mark this reply as the answer".

0 0

Replies

replied on September 26, 2014 • Show version history

Assuming this is using Quickfields with a Validation package, or Workflow you will want to use a pattern matching activity with your current token as an input. For dates, I usually use the following pattern: \d{1,2}/\d{1,2}/(\d{4})

The () choose which part of match you want to be output. Then you use this new token where you would want your four digit date to show up.

0 0

replied on September 26, 2014

Great! That worked perfectly (once I removed the extra space which I accidently copied into my pattern expression - oops). Thank you very much!

0 0

replied on September 26, 2014

If a response answered your question, please click "This answered my question" to let us know.

Thanks!

0 0

replied on September 29, 2014

It did indeed answer my question, however I did not see a link on my screen to indicate this (see below).

0 0

replied on September 29, 2014

Jeff, sorry about that. We're looking into it.

0 0

SELECTED ANSWER

replied on September 29, 2014

Hi Jeff,

The picture that Sierra pasted is actually from an old user interface. It's actually just that check mark icon.

If you hover over it, it says "Mark this reply as the answer".

0 0

You are not allowed to follow up in this post.

Question

Question

How do I truncate information within a token?

Answer

Replies

Sign in to reply to this post.