8 Replies Latest reply: Feb 10, 2017 2:28 AM by Sunny Talwar RSS

    Index of last left zero in string

    Андрей Шепель

      Colleagues, good day!

      Some questions about string fuction Index...

      I have simple table, which contain num and text values with leader zeros.

       

       

      Test
      006545
      005
      35
      45
      43
      00fdfsdfsd
      00yuturt
      0665
      0fdhfg00

       

      I need to suppress them. My idea to use left function and index of last left zero.

      How i can find this index in expr?

       

      thanks.