AnsweredAssumed Answered

Adding asterisks to a barcode case statement

Question asked by tdeppen on Mar 27, 2015
Latest reply on Mar 27, 2015 by tdeppen

Title

Adding asterisks to a barcode case statement

Post

I have the following case statement for an address barcode field, and all I want to do is know how to add "*" asterisks to the beginning and end of the returned value....OH, and I also need to know how to remove any "," (commas) from the address as well. Here is what I have so far:

Case ( 
not IsEmpty  ( Delivery Instructions ) ; TrimAll ( Delivery Instructions ; 1 ; 3 ) ; 
Location = "NONE" ; TrimAll ( Address ; 1 ; 3 ) ; 
not IsEmpty ( Location ) ; TrimAll ( Location ; 1 ; 3 ) ; 
not IsEmpty ( Address ) ; TrimAll ( Address ; 1 ; 3 )
)

Outcomes