question on right function
Trying to use Right function as below in my jsl codedt << New Column("ORIG_MARK",Character,Nominal,Formula(Right(:result,(Contains(:result,"_",3)))));The result of this statement is as below,but I intend to eliminate the "_" from every row in the ORIG_MARK column.How can I modify the above statement to accomplish this?resultORIG_MARKORIG_MARK_A_AORIG_MARK_B_BORIG_MARK_C_CORIG_MARK_D_DORIG_MARK_E_E