3 Replies Latest reply on Aug 22, 2018 11:56 AM by Vinod Somepalli

    String Convertion issue

    Roisha Pal

      Hi,

       

      I have data in my column like below . Column type Text.

       

      Code:

      00004567

      267869.00000

      C03071

      10567

       

      If I convert the column Code to Number Type, C03071 getting eliminated but other data coming correctly. Is there a way I can get out put as below so that i can get all the data even alphanumeric as well.?

       

      Code:

      4567

      267869

      C03071

      10567

       

      Thanks in Advance for your help