Hello. How do I setup an action to check if the DISCNUMBER field is blank, and if so replace it with "1/1" ?
I tried using the REPLACE type, but I can't leave the Original field blank. Ideas?
Cheers,
DJ
Hello. How do I setup an action to check if the DISCNUMBER field is blank, and if so replace it with "1/1" ?
I tried using the REPLACE type, but I can't leave the Original field blank. Ideas?
Cheers,
DJ
Action: Format value
Field: DISCNUMBER
If tag-field DISCNUMBER does not exist ...
Formatstring: $if2(%DISCNUMBER%,'1/1')
If tag-field DISCNUMBER does not exist or contains space characters ...
Formatstring: $if($neql($trim(%DISCNUMBER%),),%DISCNUMBER%,'1/1')
... or ...
Formatstring: $if($eql($trim(%DISCNUMBER%),),'1/1',%DISCNUMBER%)
DD.20100924.0509.CEST