3 Replies Latest reply on Mar 20, 2018 1:01 AM by lei.chen.0

    Substitute a char with a new line and create filter

    vijay viswanathan

      Hi

      I have field3 with a string like one:two:three how do i replace ':' with new line

       

      I tried calculated field called field3_1 with REPLACE([field3],":", CHAR(10))

       

      but the table still doesnt show with new line only the tooltip shows.

       

      Qn-2)

      Also, I need to add them as filters - not sure if that is possible