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

Question

Question

Regular expression to capture filename after certain text

asked on October 5, 2017

I am currently setting up a workflow to rename and move some shortcuts.  I'm stuck on the regular expression part that I need to capture the piece of the original shortcut name that will remain in the filename.  

 

Ex: The initial shortcut is named "3 Pending Certification Smith, Bob 123456 - Property"

where "3 Pending Certification " is static text, "Smith, Bob" is a token for the client's name, "123456" is a token for an ID number, and "Property" is a token for a property name.  The goal is to rename the shortcut to be just "Smith, Bob 123456 - Property"

 

How can I accomplish this?  To put it simply, I only need to remove the first 24 characters of the entry name.  

 

Thanks!

0 0

Answer

SELECTED ANSWER
replied on October 5, 2017

You can just use the token calculator to create a new token which you can reassign as the new file name. works like excel

mid("starting token name",starting position, length)

ie: mid("shortcut name token,25,100)

1 0
replied on October 5, 2017

That did the trick - thank you!

Incidentally, I did have a For Each Entry scenario wherein each entry name is added to the multi-value token to be listed in an email.  I checked Apply Index to the token in the calculator and specified the For Each Entry: Instance as the index value to account for this.  

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.