3 Replies Latest reply: Jun 27, 2012 2:29 AM by Apurva Jha RSS

    Delete a value

      I have the following values within a column.


      "2012-05-25 08:23:10
      "2012-05-25 08:23:20
      "2012-05-25 08:23:34
      "2012-05-25 08:23:43
      "2012-05-25 08:24:02
      "2012-05-25 08:24:14
      "2012-05-25 08:24:49
      "2012-05-25 08:25:01
      "2012-05-25 08:25:14
      "2012-05-25 08:25:25
      "2012-05-25 08:25:46
      "2012-05-25 08:25:59
      "2012-05-25 08:26:09

       

      I need to delete only the " all rows.

        • Re: Delete a value
          Mayil Vahanan Ramasamy

          Hi,

           

               Try this,

           

              

          T1:
          Load * Inline
          [
          Testing

          "2012-05-25 08:23:10
          "2012-05-25 08:23:20
          "2012-05-25 08:23:34
          "2012-05-25 08:23:43
          "2012-05-25 08:24:02
          "2012-05-25 08:24:14
          "2012-05-25 08:24:49
          "2012-05-25 08:25:01
          "2012-05-25 08:25:14
          "2012-05-25 08:25:25
          "2012-05-25 08:25:46
          "2012-05-25 08:25:59
          "2012-05-25 08:26:09

          ];


          Load Right(Testing,Len(Testing)-1) as ValidDate Resident T1;

           

          Hope it helps

          • Re: Delete a value
            Edgar Baltazar

            Hi Osvaldoberg! you can use purgechar function it's very easy...

             

            here is the syntax...

             

            PurgeChar(s1, s2)

            Returns the string s1 less all characters contained in string s2.

             

            So when loading the field where is contained this data that you want to clean just use this

             

            PurgeChar(field,'"') as field

             

            Regards!