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

    help with expression

    archana.chandra

      I have a data coming in as

      A_Aug2016

      sept2016

       

      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)