4 Replies Latest reply: Apr 25, 2016 6:49 AM by Marcus Sommer RSS

    How to remove spaces from the data string on load from qvd file

    kapil rathore

      I have data loaded in qvd file that looks like -

       

      IDVALUE
      11interface; interface1;   interface3
      12interface; interface2; interface5

       

       

      upon loading I want to remove blank spaces from VALUE Column  For all the rows -

       

      expected output -

       

      IDVALUE
      11interface;interface1;interface3
      12interface;interface2;interface5

       

       

      Can anyone please tell me how to do that ?