Jump to content

Increment an issue number in a File name

Recommended Posts

I am trying to edit an if/else rule and I want to find the best way to increment or search for a file name based off of another data field. Example below.



We have a cover image for a magazine called SH_M097_COVER5_001.pdf. The actual number of the issue is 6. It's a long story. I'm trying to find a way to say this below:



if (Field("CoverTemplate") =="FC-NP001";

return SH_M097_COVER5_001.pdf




But this would have the issue number plus 91, so the 097 would be the only part of that file name that changes in the logic. I'm sure there is a regex or a way to increment that number, I'm just not sure how to tackle it. I'm trying to solve a problem by using a file name that exists.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...