7 Replies Latest reply: Aug 15, 2013 10:01 AM by Sumita Chawla RSS

    Replace one single character from all columns

      Hi All,




      I have a requirement,In my table  I want to replace \n character with null() from all column.

      I can use if condition

      if(Col1='\n',null(),Col1) as Col1


      But in my table there are above 100 coumn. So is there any alternative let me know..