7 Replies Latest reply: Apr 13, 2018 3:17 PM by Sunny Talwar RSS

    Counting and filtering, SubField()

    shimon Gowda

      Hi,

       

      I want to know if there's a way i can use Subfield() funtion to keep the second word in a 2 word field, if it contains 1 it should remain as it is.

      Eg,

       

      Apple red = red

      Sky blue = blue

      Yellow = yellow

      Pink = pink.

       

      I used the code,

      [CategoryName] = ' ',(SubField(CategoryName , ' ' , 2) As new_column.

       

      But the result I am getting is only red and blue. It is not counting the single word fields.

      I also used, if condition,

       

      =If(CategoryName = ' ' ,(SubField(CategoryName,' ',2), CategoryName)

      But it doesnt seem to work correctly.