5 Replies Latest reply: May 9, 2017 7:04 AM by Sasi Vardhan KV RSS

    Fine & Replace

    Sasi Vardhan KV

      Hi Team,

       

      Here is the table loaded.

       

      Sample:

      LOAD * INLINE [

          S.No, Region

          1, USA.Atlanta

          2, USA.California

          3, USA.California.Bayarea

          4, India.Karnataka.Tamilnadu.Chennai

      ];

       

      Now the requirement is to replace . with space(" ")

       

      Region

      USA Atlanta

      USA California

      USA California Bayarea

      India Karnataka Tamilnadu chennai

       

      Can please one please let me know any function to use.