How to replace an empty string when a output field has null value? ADDRESS_1, `${ISNULL(UNIT_NUMBER, '''', UNIT_NUMBER)}`, CITY, STATE, ZIP

Permanently deleted user

June 25, 2020 14:47

0

• 

  Guillaume Ruelle

  June 26, 2020 11:23

  I would put an create an empty value (Create value activity), then test if the UNIT_NUMBER is null ( If activity), then configure two Set Property activities depending on the result of the If (or Text Replace activities). If you find a javascript way to do it, please share :)

  0
• 

  Berend Veldkamp

  July 03, 2020 14:56

  This code

  $someValue.result || ""

  will return an empty string if 'someValue.result' is either undefined or null (or 0, if the variable is not a string but a number).

   

  0

Please sign in to leave a comment.