2 Replies Latest reply on Sep 29, 2017 6:20 AM by Jennifer VonHagel

    How to eliminate the word "NULL" by combiing more fields at the same time?

    Dilyana Suleymanova

      Hi there

      I have follow problem: I have to combine 6 columns. Not every column has a value.

      I tried out two ways:


      1. Right click --> Create combined fields


      this is my result:


      I have "Null" as a word in the columns without values


      2. I created a calculation field:

      TRIM([Film Name_Teil1]+' '+[Film Name Teil 2]+' '+[Film Name 3]+' '+[Film Name Teil 4]+' '+[Film Name Teil 5]+' '+[Film Name Teil 6])


      This is my result


      In the fields where I habe less then 6 words, I get "Null" (not as a word)


      How can I combined fields without Null as a word?


      Thank you!