10 Replies Latest reply on Jun 7, 2016 5:22 PM by msa s

    Column with string data type, how to remove special characters?

    Tracey Dong

      Before look like these:

       

      DTSS;#

      DTSS

      DTSS;#8

       

      Want to change to these:

      DTSS

      DTSS

      DTSS

       

      I tried LEFT([Business Segment],FIND([Business Segment],";#")-1), but it doesn't work for attributes without the special characters.

       

      Please help!

      Thank you.