2 Replies Latest reply: Jan 29, 2016 8:32 AM by patrico mesri RSS

    How to replace an specific character under a column

    patrico mesri

      Hi guys.

      I have a question on what must be an easy task... I have to replace an specific character under a column.

       

      This is what I'm loading in Sense.

       

      Name
      John,Green
      Mike,Red
      Stephanie,Roberts
      Patrick Isaac,Ortner

       

      I have to replace the "," by " " (one space)

      How do I do it? Where do I put in the load script?

       

      Thank you in advance.

      Regards.