4 Replies Latest reply on Nov 17, 2016 12:47 PM by archana.chandra

    help with expression


      I have a data coming in as




      my requirement is to have

      Aug 2016

      Sep 2016


      my expression below  Gives me _Aug 2016 & Sept 2016 . how  can I modify my expression to get desired out put . As far as my understanding goes I need to use split function again on first chunk but some how I am not able to put it right. Any help will highly be appreciated.


      Left(Right(split([Table Name],'.',1),8),4)+' '+Right(split([Table Name],'.',1),4)