4 Replies Latest reply: Oct 18, 2018 11:15 PM by Chia Jia Xiang RSS

    get first 2 characters of field and add '20' as year

    Chia Jia Xiang

      Hi All,

       

      I currently have this STRM1 data, where 1220 represents term 2 of year 2012, 1420 represents term 2 of year 2014 and so on. What i want to be able to do is to get the first 2 characters of the field and add a '20' in front to display as year.

       

      For e.g:

      get first 2 characters from STRM1 , 1220, '12', will be retrieved

      Then add a '20' in-front , to show as 2012 in a new column

       

      [Cell Name]


      STRM1
      1220
      1420
      1430
      1510

       

      Anyone can help?

      Thank you for your time.