ReminderVDP Posted June 21, 2019 Share Posted June 21, 2019 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. Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted June 21, 2019 Share Posted June 21, 2019 Something like this: return "SH_M" + FormatNumber("000", Int(Field("IssueNumber")) + 97) + "_COVER5_001.pdf"; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.