I'm trying to use a diesel expression to display a custom sheet set property. However, I'd like to remove the first 3 characters from the field and display only the last 5 characters.
Example:
Custom Sheet Set Property "CUSTOM 1" = XX-12345
Display on sheet = 12345
I have tried this,
$(substr,%<\AcSm SheetSet.CUSTOM 1>%,4,8)
but when i remove the sheet from the current sheet set to a new sheet set with the same custom properties (but with different values) the text field displays the old information still. When I open the field dialog box, the expression has been changed and reads
$(substr,XX-12345,4,8)
Any help would be much appreciated,
Thanks
