replace blank field?


#1

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


#2

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