5 Replies Latest reply on Jun 18, 2009 8:39 AM by 707296

    Trim non-breaking space

      I have got some columns imported with leading non-breaking space (chr(160)) when I imported them from excel. I need to clean it up. How do I trim the non-breaking space out of the column.

      I tried replace(column, chr(160), '') but that did not work. Can anyone help me with this? Any help is greatly appreciated.